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
Wick" in the same cell.
I can do it by using "alt + enter", but it is very difficult to do the same for 1300 names. please help me solve it.
please find the attachment for example.
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 .
- Thanks for the rescue. will try the fix on bulk files. Thanks again
