Split cell text

[Rafaelpresa123]

Hello

I have a database to process and there are values on same cell (separate with / or | ) i need to split cell into name cell and surname cell

Please check file attach

[Bo_Ry]

Please try at B2
=TRIM(MID(SUBSTITUTE(TRIM(MID(SUBSTITUTE(SUBSTITUTE($A2,"/","|"),"|",REPT(" ",99)),CEILING(COLUMNS($B2:B2)/2,1)*99-98,99))," ",REPT(" ",99)),MOD(COLUMNS($B2:B2)-1,2)*99+1,99))

[AliGW]

A little shorter, in B2 copied across and down:

=TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($A2," | "," ")," / "," ")," ",REPT(" ",99)),(99*COLUMNS($B2:B2))-98,99))

[Rafaelpresa123]

Please try at B2
=TRIM(MID(SUBSTITUTE(TRIM(MID(SUBSTITUTE(SUBSTITUTE($A2,"/","|"),"|",REPT(" ",99)),CEILING(COLUMNS($B2:B2)/2,1)*99-98,99))," ",REPT(" ",99)),MOD(COLUMNS($B2:B2)-1,2)*99+1,99))

Yours seem to work pretty fine. Separates 1st 2nd 3rd and surname
Thank you very much

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.