I need to remove the text in the left most part of the cell up to and
including the point that includes a space.

For example the cell reads: 51253 Axle Housing

I want the 51253 and the space go away.

Thanks

Assumptions: 1 There is always at least 1 space, and 2 You always want to
remove the text up to and including the first space only.

=RIGHT(A1,LEN(A1)-FIND(" ",A1))

Hope this helps.
--
John C


"Scott" wrote:

I need to remove the text in the left most part of the cell up to and
including the point that includes a space.

For example the cell reads: 51253 Axle Housing

I want the 51253 and the space go away.

Thanks

Try this (assume A1 is the cell with the data)

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

--


Regards,


Peo Sjoblom

"Scott" <Scott @discussions.microsoft.com wrote in message
...
I need to remove the text in the left most part of the cell up to and
including the point that includes a space.

For example the cell reads: 51253 Axle Housing

I want the 51253 and the space go away.

Thanks

That did it, thank you very much!

Scott

"John C" wrote:

Assumptions: 1 There is always at least 1 space, and 2 You always want to
remove the text up to and including the first space only.

=RIGHT(A1,LEN(A1)-FIND(" ",A1))

Hope this helps.
--
John C


"Scott" wrote:

I need to remove the text in the left most part of the cell up to and
including the point that includes a space.

For example the cell reads: 51253 Axle Housing

I want the 51253 and the space go away.

Thanks

Thanks for the feedback.
--
John C


"Scott" wrote:

That did it, thank you very much!

Scott

"John C" wrote:

Assumptions: 1 There is always at least 1 space, and 2 You always want to
remove the text up to and including the first space only.

=RIGHT(A1,LEN(A1)-FIND(" ",A1))

Hope this helps.
--
John C


"Scott" wrote:

I need to remove the text in the left most part of the cell up to and
including the point that includes a space.

For example the cell reads: 51253 Axle Housing

I want the 51253 and the space go away.

Thanks