Cell with numbers and names, need to devide them

  • Thread starter Thread starter Lion2004
  • Start date Start date
L

Lion2004

Hello,

I have list of names and digits from A1 to A100. It is shown as
"PeeterXcrter 5696959594"
I need to devide 1 cell thisway, that this number will go to B row.

Thank you for help.

Peter
 
Hi,

Provided your data are as in the example below then try this in column B and
drag down:-

=MID(A1,FIND(" ",A1,1)+1,LEN(A1))

If you have more than 1 space in yor data then post back.

Mike
 
You may want to select the column and then use Data|Text to columns (xl2003 menu
system).
 
Back
Top