Thread: masking
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
hklemmons hklemmons is offline
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