Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
a macro for inserting
insert it in a column to the right (assume a new column B)
=Left(A1,6) & "-" & mid(A1,7,255) then drag fill all the way down. now select the column and do Edit=copy, then Edit=Paste Special and select values. Now delete the original column. So I guess you are the nerd that needs to do it. -- Regards, Tom Ogilvy "spreadsheet monkey" wrote: I need a solution/macro to insert a minussign (-) into a 10 digit number between digit 6 and 7 (to get a number looking like this xxxxxx-xxxx) I need to do it in a single column for all 65 536 lines of code in the spreadsheet. who of you is nerd enough to tackle this challenge? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
a macro for inserting | Excel Programming | |||
macro for inserting a row | Excel Programming | |||
inserting row macro | Excel Discussion (Misc queries) | |||
Inserting A Row Macro | Excel Programming | |||
Inserting a Row With Macro - Help | Excel Programming |