ExcelBanter - Delete first word

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Delete first word (https://www.excelbanter.com/excel-discussion-misc-queries/203291-delete-first-word.html)

Deb

Delete first word

How can I delete the first word in column A?

Thank you
--
deb

Max

Delete first word

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
---

Ron Rosenfeld

Delete first word

On Sat, 20 Sep 2008 16:31:01 -0700, deb wrote:

How can I delete the first word in column A?

Thank you

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

All times are GMT +1. The time now is 10:31 AM.