formula to delete last word in a column

  • Thread starter Thread starter roger_home
  • Start date Start date
R

roger_home

Can someone give me a formula to delete last word in a column?

Thanks
roger901
 
One way:

=RIGHT(A1,MATCH(" ",MID(A1,LEN(A1)+1-ROW(INDIRECT("1:"&LEN
(A1))),1),0)-1)

Array-entered (press ctrl + shift + enter).

HTH
Jason
Atlanta, GA
 
Do you have a column of mixed numeric and text entries and you want to
delete the last text entry? What if the last text entry is more than
one word, delete only the last word or the entire entry?

This will probably require VB code to accomplish.

More details, please....
 
Sorry, I wasn't paying attention. The formula will
extract the last word. Use this instead:

=LEFT(A1,LEN(A1)-MATCH(" ",MID(A1,LEN(A1)+1-ROW(INDIRECT
("1:"&LEN(A1))),1),0))

Also array-entered.

Jason
 
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

Help needed 0
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Excel - formula last data cell 2
Excel Subtracting multiple columns from another column 3
Deleting a word from a Cell 2
automatically average the last 4 columns 10
Excel Help to copy information from one row at a time to another sheet 1
Formula for the last column value 5

Back
Top