Dividing information within a cell.

  • Thread starter Thread starter Andrea
  • Start date Start date
A

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
 
Hi
if the data is separated by comas use
=TRIM(LEFT(A1,FIND(",",A1)-1))

also have a look at 'Data - Text to columns'
 
Hi
then you may provide an example of your data :-)
How is your data structured, how are the elements separated (spaces?)
 
2443 ACEVEDO, KATRINA M 0.00

All this information is in A3. I would like it seperated
into three different columns. Maybe :)
 
Its all in A3 right now... i need 2443 in cell B3,
Acevedo, Katrina M in cell C3, and 0.00 in cell D3
 
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," ",""))))))
 
Back
Top