Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formula to delete last word in a column
Can someone give me a formula to delete last word in a column? Thanks roger901 -- roger_home ------------------------------------------------------------------------ roger_home's Profile: http://www.excelforum.com/member.php...o&userid=16434 View this thread: http://www.excelforum.com/showthread...hreadid=346091 |
#2
|
|||
|
|||
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 -----Original Message----- Can someone give me a formula to delete last word in a column? Thanks roger901 -- roger_home --------------------------------------------------------- --------------- roger_home's Profile: http://www.excelforum.com/member.php? action=getinfo&userid=16434 View this thread: http://www.excelforum.com/showthread...hreadid=346091 . |
#3
|
|||
|
|||
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.... -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=346091 |
#4
|
|||
|
|||
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 -----Original Message----- 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 -----Original Message----- Can someone give me a formula to delete last word in a column? Thanks roger901 -- roger_home -------------------------------------------------------- - --------------- roger_home's Profile: http://www.excelforum.com/member.php? action=getinfo&userid=16434 View this thread: http://www.excelforum.com/showthread...hreadid=346091 . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
Search column and move text formula | Excel Discussion (Misc queries) | |||
ISSUE: Using VBA to Delete a Column | Excel Discussion (Misc queries) | |||
what formula do i put for column m = column k minus column l in e. | Excel Discussion (Misc queries) | |||
how to enter a formula using column() function for a range | Excel Worksheet Functions |