Need to remove text in specific place

[Scott]

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

 

[John C]

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.

 

[Peo Sjoblom]

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

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

--


Regards,


Peo Sjoblom

 

[Scott]

That did it, thank you very much!

Scott

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]

Thanks for the feedback.
--
John C

That did it, thank you very much!

Scott