ADDING DASHES WITHIN NUMBERS IN A COLUMN

P

paulp

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
 
D

Dave Peterson

You could use another column with formulas like:

=left(a1,9)&"-"&right(a1,2)

if all the cells contain 11 character numbers.
 
G

Gary''s Student

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

=LEFT(A1,9) & "-" & RIGHT(A1,2)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Finding the proper style field and the numbered paragraph value within the style 0
formatted to place dashes within numbers formatted as text 1
Adding a dash 3
Formatting a cell - remove a dash 5
Adding a dash to phone numbers 2
insert a dash 5
adding * to text to column 4

Top