Split numeric and text

  • Thread starter Thread starter Murali Rajagopal
  • Start date Start date
M

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..
 
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)
 
Hi,
In cell B1 enter

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

if this helps please click yes, thanks
 
Thanks Valko..

T. Valko said:
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)
Click to expand...
 
Back
Top