View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
paulp paulp is offline
external usenet poster
 
Posts: 3
Default ADDING DASHES WITHIN NUMBERS IN A COLUMN

i have a column of part numbers (1391 lines) and i need to insert a
dash/hyphen into each number at a specific place. for example, one original
number is

HQ505279513

and i need it to be

HQ5052795-13

this then has to be repeated for all the other numbers in that column. am i
able to perform this in excel 2003?

thanks,
paul