ADDING DASHES WITHIN NUMBERS IN A COLUMN
You could use another column with formulas like:
=left(a1,9)&"-"&right(a1,2)
if all the cells contain 11 character numbers.
paulp wrote:
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
--
Dave Peterson
|