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

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

ADDING DASHES WITHIN NUMBERS IN A COLUMN
 

Say your data is in column A. In another column:

=LEFT(A1,9) & "-" & RIGHT(A1,2)
--
Gary''s Student - gsnu200780


"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