Split numeric and text
 

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..

Split numeric and text
 

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)

--
Biff
Microsoft Excel MVP


"Murali Rajagopal" <Murali wrote in
message ...
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..

Split numeric and text
 

Hi,
In cell B1 enter

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

if this helps please click yes, thanks

"Murali Rajagopal" wrote:

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..

Split numeric and text
 

Thanks Valko..

"T. Valko" wrote:

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)

--
Biff
Microsoft Excel MVP


"Murali Rajagopal" <Murali wrote in
message ...
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..

Split numeric and text
 

Thanks Eduardo it realy works..

"Eduardo" wrote:

Hi,
In cell B1 enter

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

if this helps please click yes, thanks

"Murali Rajagopal" wrote:

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..

Split numeric and text
 

your welcome, thanks for the feedback

"Murali Rajagopal" wrote:

Thanks Eduardo it realy works..

"Eduardo" wrote:

Hi,
In cell B1 enter

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

if this helps please click yes, thanks

"Murali Rajagopal" wrote:

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..

Split numeric and text
 

You're welcome!

--
Biff
Microsoft Excel MVP


"Murali Rajagopal" wrote in
message ...
Thanks Valko..

"T. Valko" wrote:

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)

--
Biff
Microsoft Excel MVP


"Murali Rajagopal" <Murali wrote in
message ...
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..