Split text into columns

can't you not just use home -> data -> text to columns and then delimit per space?

Try...........

1] In B2, enter formula :

=IFERROR(0+TRIM(MID(SUBSTITUTE(SUBSTITUTE(": "&$A2,CHAR(10),": "),": ",REPT(" ",LEN($A2))),COLUMN(A1)*LEN($A2),LEN($A2))),"")

and, select B2 >> Custom cell Format: yyyy-mm-dd

2] In C2, enter formula :

=IFERROR(TRIM(MID(SUBSTITUTE(SUBSTITUTE(": "&$A2,CHAR(10),": "),": ",REPT(" ",LEN($A2))),COLUMN(B1)*LEN($A2),LEN($A2))),"")

3] Then, select B2 and C2 copied across to I2 and all copied down

Regards
Bosco

This error seems to appear!
'home -> data -> text to columns and then delimit per space' is not a proper way to go through I guess because I cannot see there under rows of a cell...
When it comes to the formula, I am still a beginner in excel and I don't easy figure out these errors. Maybe I just need to replace '','' with '';'' ?


Thank you for your help!

Originally Posted by EHH

... Maybe I just need to replace '','' with '';'' ? ....

Yes, although you are in London, you seem to be using a German-language version of Excel, so your formulae need to use semicolons ( ; ) instead of commas ( , ).

Hope this helps.

Pete

Thank you much