Cell Text to Column

[mspincus]

After importing pdf info into an excel spreadsheet, all o the data comes into 1 cell. I have a name, phone number and email address. Ultimately I need them in 4 rows so I can export it into csv format and them import these names into another program. An example - call a1 has Particia LowTower (555)-555-5555 patricia@gmailatgmail.com. What I have been doing is putting a comma after the first name, lastname, phone number,, email address. and then I go to text to column and it works. is there an easier way than 1X1

 

[smitpau]

Yeah if you used LEFT and MID functions in each column per data type, assuming each string i.e name is the same number of characters that would split it.

For example (assume the full text is in A1) =LEFT(A1,17) would get Particia LowTower then =MID(A1,19,14) would get the (555)-555-5555 phone number.

Hope that helps.

 

[etaf]

use a space as delinator - if the name is ok, and not got 2 names ie marie ann

 

[kweaver]

Here's another solution with your data in the A column and specifically meets the format of the example you gave. But, etaf's solution is probably the easiest.
B column fill down:

=LEFT(A1,FIND(" ",A1)-1)

C column fill down:

=MID(A1,FIND("(",A1),14)

D column fill down:

=RIGHT(A1,LEN(A1)-FIND(CHAR(160),SUBSTITUTE(A1," ",CHAR(160),3)))

 

[smitpau]

Did you find any of this helpful mspincus?