| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Remove Text
I need a function to remove text from a cell and leave 5 digits at the very
end of the string. For example: Company One 11111 Company 2 22222 Com Three 33333 Co. Four 44444 Co. 5 55555 What is to the left of the numbers that I need to keep varies in length. So I need to remove everything that isn't the furthest right 5 characters in the string. Any help is greatly appreciated. Thank you in advance. Brandon |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text - Remove text Item No.99 (First 2 Chars) and move to end | Excel Discussion (Misc queries) | |||
| Easiest way to remove text from a cell that has text and numbers? | Excel Discussion (Misc queries) | |||
| Filter text in a column by its Indent, to remove certain text | Excel Discussion (Misc queries) | |||
| want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
| want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
Threaded Mode
