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 |
removing text within a cell
thank you!! *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
All times are GMT +1. The time now is 01:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com