Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
inputting data with a "+" sign | Excel Discussion (Misc queries) |