Dividing information within a cell.

[Andrea]

I have downloaded a report into excel, and it has put all
the information in to one cell in column A. Example - row
1, column A i have name, address, phone # in that one
cell. I know there is a formula that you can select the
text in column 1A and put just the name into cell 1B. Can
anyone help me please.

Thank You,
Andrea

 

[Frank Kabel]

Hi
if the data is separated by comas use
=TRIM(LEFT(A1,FIND(",",A1)-1))

also have a look at 'Data - Text to columns'

 

[Guest]

What if the information is not seperated by commas.

 

[Frank Kabel]

Hi
then you may provide an example of your data
How is your data structured, how are the elements separated (spaces?)

 

[Guest]

2443 ACEVEDO, KATRINA M 0.00

All this information is in A3. I would like it seperated
into three different columns. Maybe

 

[Frank Kabel]

And HOW should it be separated?

 

[Guest]

Its all in A3 right now... i need 2443 in cell B3,
Acevedo, Katrina M in cell C3, and 0.00 in cell D3

 

[Frank Kabel]

Hi
try the following formulas
B3:
=TRIM(LEFT(A3,FIND(" ",A3)-1))

C3:
=TRIM(MID(A3,FIND(" ",A3)+1,SEARCH("^^",SUBSTITUTE(A3,"
","^^",LEN(A3)-LEN(SUBSTITUTE(A3," ",""))))-FIND(" ",A3)-1))

D3:
=TRIM(RIGHT(A3,LEN(A3)-SEARCH("^^",SUBSTITUTE(A3,"
","^^",LEN(A3)-LEN(SUBSTITUTE(A3," ",""))))))