Cell with numbers and names, need to devide them
 

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

Cell with numbers and names, need to devide them
 

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

"Lion2004" wrote:

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

Cell with numbers and names, need to devide them
 

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

Lion2004 wrote:

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

--

Dave Peterson