Delete first word

M

Max

How can I delete the first word in column A?

One way

Try in B1:
=IF(LEN(A1)=0,"",IF(ISERROR(SEARCH(" ",A1)),A1,TRIM(MID(A1,SEARCH("
",A1),99))))
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,000 Files:359 Subscribers:56
xdemechanik
---
 
R

Ron Rosenfeld

How can I delete the first word in column A?

Thank you
Click to expand...

You can use a formula in some other column:

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

Then copy the results and do a paste special/values over the original.

There are other ways, using VBA and macros, if this is not sufficient.
--ron
 
Top