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
|