Need to remove text in specific place
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
|