delimited text in excel 2

[dbpcar]

I have an excel mailing list that has the address and phone number together as below:

"Costa Mesa CA 92626
714-557-2670"
This entry is in one cell, separated by the computer graphic for "enter"

I need to identify the delimiter in Text To Columns. I cannot come up with a way to do this. Any ideas?

dbpcar

 

[GlennUK]

You can split the contents of the column using formulae, instead of using Text To Columns. If column A has the data, then use this formula in cell B1 ( and copy down ) to get the address ...

=IF(ISERROR(FIND(CHAR(10),A1)),A1,MID(A1,1,FIND(CHAR(10),A1)-1))

and use this formula in cell C1 ( and copy down ) to get the phone number ...

=IF(ISERROR(FIND(CHAR(10),A1)),"",MID(A1,FIND(CHAR(10),A1)+1,250))

That should do what you want.
Glenn.

 

[dbpcar]

brilliant and perfect, thank you!
dbpcar