Forum Discussion
Solved
needed help
Need to work on an excel sheet with 1300 names on it. I want to write every name first name on the top of second name in the same cell. for ex : "John Wick" as "John ...
If you have O365, you can use this (shown on row 3):
=LET(d,A3,pos,FIND(", ",d,1),LEFT(d,pos-1)&CHAR(10)&MID(d,pos+2,LEN(d)))If you don't, you can use this:
=LEFT(A1,FIND(", ",A1,1)-1)&CHAR(10)&MID(A1,FIND(", ",A1,1)+2,LEN(A1))
If you have O365, you can use this (shown on row 3):
=LET(d,A3,pos,FIND(", ",d,1),LEFT(d,pos-1)&CHAR(10)&MID(d,pos+2,LEN(d)))
If you don't, you can use this:
=LEFT(A1,FIND(", ",A1,1)-1)&CHAR(10)&MID(A1,FIND(", ",A1,1)+2,LEN(A1))
Hello,
Both the formulas are not working .please find the attachment and help me. Thanks .
- Why do you want to do this? Would it be better if each word were on a different row?
- Thanks for the rescue. will try the fix on bulk files. Thanks again
