Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Removing select text from a cell Tim Millar New Users to Excel 1 January 15th 09 02:28 PM
removing text characters from a cell volleygods Excel Worksheet Functions 12 December 24th 08 05:07 PM
Removing text from a cell with text and numbers DoubleZ Excel Discussion (Misc queries) 2 July 8th 08 10:14 PM
Removing Numbers from a Cell that also has text. [email protected] Excel Discussion (Misc queries) 2 March 1st 08 09:05 PM
removing part of text string to another cell jamie_k Excel Discussion (Misc queries) 2 July 24th 06 10:57 AM


All times are GMT +1. The time now is 11:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"