View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steved Steved is offline
external usenet poster
 
Posts: 519
Default Using VBA for Inputting a "-"

Hello from Steve Dee

In Column B:B I have a contract Number

for example 789-6
I would like the above to change to please 7-89-6

Another example I have X677-6
I would like the above to change to please X6-77-6

The script would look for the first Digit and then insert "-"
Now if it found a "X" it would insert "-" after the next digit
for example X1- or X7- or X5-

Is it possible please to have the above Look in B:B and acheive the "-"
meaning inputting 7- or X6- using the same script.

Thankyou.