| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to insert dashes in a column of numbers | New Users to Excel | |||
| Adding columns containing numbers with dashes | New Users to Excel | |||
| Adding Dashes to a 25 digit alphanumeric cell | Excel Discussion (Misc queries) | |||
| Convert phone numbers with dashes in them to just numbers | Excel Discussion (Misc queries) | |||
| Convert phone numbers with dashes in them to just numbers | Excel Discussion (Misc queries) | |||
Threaded Mode
