View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default Need to remove text in specific place

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