Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to get the right-most word from TEXT
Please let me know if there is a easy way to do this:
Cat Dog monkey = monkey This is a test = test I love you = you Thanks. BC |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to get the right-most word from TEXT
Try this:
For text, including spaces, in A1 B1: =RIGHT(A11,LEN(A11)-LOOKUP(LEN(A11),FIND(" ",A11,ROW(INDEX($A:$A,1,1):INDEX($A:$A,LEN(A11),1) )))) That formula pulls the text after the last space from A1. Does that help? *********** Regards, Ron XL2002, WinXP "BC" wrote: Please let me know if there is a easy way to do this: Cat Dog monkey = monkey This is a test = test I love you = you Thanks. BC |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to get the right-most word from TEXT
Some typos in that formula:
B1: =RIGHT(A11,LEN(A11)-LOOKUP(LEN(A11),FIND(" ",A11,ROW(INDEX($A:$A,1,1):INDEX($A:$A,LEN(A11),1) )))) The refs to A11 should be to A1 Correct formula: B1: =RIGHT(A1,LEN(A1)-LOOKUP(LEN(A1),FIND(" ",A1,ROW(INDEX($A:$A,1,1):INDEX($A:$A,LEN(A1),1))) )) (Sorry for any confustion) *********** Regards, Ron XL2002, WinXP "Ron Coderre" wrote: Try this: For text, including spaces, in A1 B1: =RIGHT(A11,LEN(A11)-LOOKUP(LEN(A11),FIND(" ",A11,ROW(INDEX($A:$A,1,1):INDEX($A:$A,LEN(A11),1) )))) That formula pulls the text after the last space from A1. Does that help? *********** Regards, Ron XL2002, WinXP "BC" wrote: Please let me know if there is a easy way to do this: Cat Dog monkey = monkey This is a test = test I love you = you Thanks. BC |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to export text from Excel to Word | Excel Discussion (Misc queries) | |||
How to export text from Excel to Word | New Users to Excel | |||
Text disappears when word wrap is used | Excel Discussion (Misc queries) | |||
Upside-down text in Word and Excel. | Excel Discussion (Misc queries) | |||
Text not copying as text from Word to Excel 2003 | Excel Discussion (Misc queries) |