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))
Thanks for the rescue. will try the fix on bulk files. Thanks again