Formula for separate

[issa.o]

Hi friends I have fully name three names in column A I want to separate each name to be in different column B,C and D
Thanks alot

[AliGW]

You might want to go back to your previous thread and say thank you to those of us who helped you: https://www.excelforum.com/excel-for...combining.html

You will also need to mark that thread as solved. This forum runs on goodwill, and nothing erodes this faster than your lack of common courtesy.

In B2 copied across and down:

=IFERROR(TRIM(MID(SUBSTITUTE($A2," ",REPT(" ",100)),COLUMN(A1)*100-99,100)),"")

[issa.o]

It does not work because i need each name to be in separate column first name to be in column b2 second name to be in column c2 and third name to be in column d2

[AliGW]

That's what it does.
AliGW on MS365 Beta Channel (Windows 11) 64 bit

	A	B	C	D
1	Christopher Robin Milne	Christopher	Robin	Milne
2		=IFERROR(TRIM(MID(SUBSTITUTE($A1," ",REPT(" ",100)),COLUMN(A1)*100-99,100)),"")

Sheet: Sheet1

[alansidman]

In B2 and copy down =LEFT(A2,FIND(" ",A2,1))
in C2 and copy down =MID(A2,FIND(" ",A2),FIND(" ",A2))
in D2 and copy down =RIGHT(A2,LEN(A2)-LEN(B2)-LEN(C2))