Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
removing text within a cell
This might be simple but I can't figure it out. I have a
cell that is grabbing information from somewhere. For example: the cell reads 4891-010-501 and I want another cell to reference it but only to grab the last three numbers (501) I need this function and will need it over and over again for something we do. The cell could read any number in the 10 digit sequence with dashes in them but will always end in a 3 digit number and we always want just the last 3 numbers to display. any help would be greatly appreciated and can be emailed to me at Thank you, Dennis |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
removing text within a cell
thank you!! *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing select text from a cell | New Users to Excel | |||
removing text characters from a cell | Excel Worksheet Functions | |||
Removing text from a cell with text and numbers | Excel Discussion (Misc queries) | |||
Removing Numbers from a Cell that also has text. | Excel Discussion (Misc queries) | |||
removing part of text string to another cell | Excel Discussion (Misc queries) |