Delete first word

  • Thread starter Thread starter deb
  • Start date Start date
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
---
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting and deleting 7
DELETE ALL EXCEPT LETTER OF A WORD 2
Duplicates Deletion ? 2
Word VBA for deleting Selected Row 0
Macro to Delete first words in a column 12
Use the first word only 4
How toChange color of first letter inEach word ofA column at once 1
How to concatonate two words with first word in BOLD format? 3

Back
Top