| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 | |||
Hybrid Mode
