Split numeric and text

[Murali Rajagopal]

I have a numeric and text in the same cell, I want to remove the nummeric and
I want the text to be in the next column.. Please help how to do this..

for example: Cell A1 contains some numeric and text with space inbetween
nummeric and text ie,

cell A1 - 5823 Peter
cell A2 - 23 John

I want only the names peter and John in the next cell ie, B1 and B2..

Thanks..

 

[T. Valko]

Assuming the numeric portion is *always* a contiguous string. In other
words, you won't have something like this:

123 45 678 Peter

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

 

[Eduardo]

Hi,
In cell B1 enter

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

if this helps please click yes, thanks

 

[Murali Rajagopal]

Thanks Valko..

Assuming the numeric portion is *always* a contiguous string. In other
words, you won't have something like this:

123 45 678 Peter

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

 

[Murali Rajagopal]

Thanks Eduardo it realy works..

Hi,
In cell B1 enter

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

if this helps please click yes, thanks

 

[Eduardo]

your welcome, thanks for the feedback

Thanks Eduardo it realy works..

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Thanks Valko..