LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default masking

How can delete the first 6 charaters or numbers from the front end a a
string. I am sure this can be done with a macro, however I am unsure of the
code.(Example)
2145mm2356.110 jimmy joe bob I want to only extract the 2356.110 and place
it in an adoining cell or extract the first six charaters and put them in
another cell example 2145mm
 
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
Masking out characters in a cell dnardi Excel Worksheet Functions 9 December 18th 07 08:04 PM
Display masking goto_guy Excel Discussion (Misc queries) 2 March 30th 06 11:38 PM
Masking numbers RNeducator Excel Worksheet Functions 2 December 2nd 05 02:25 PM
Masking character Joe Excel Programming 1 September 13th 04 04:17 AM
Bit Masking Merlyn Knight Excel Programming 2 March 5th 04 08:19 AM


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

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

About Us

"It's about Microsoft Excel"