Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dashes I want Dashes
Hello I have 3700 rows , Column A is alphanumeric e.g. BR100011. I
need to convert this so that it looks like this BR-1000-11. I tried - format- custom- ##-####-## but it does not work. HELP please thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dashes I want Dashes
hi
If data is all the same length, do this add a column to the right of the data column and put this formula in =LEFT(I10,2) & "-" &MID(I10,3,4) & "-" & RIGHT(I10,2) copy down to as far as you need. the copy the formula column and pastespecial as values. delete the non-dash column. you got dashes regards FSt1 Re "Marilyn" wrote: Hello I have 3700 rows , Column A is alphanumeric e.g. BR100011. I need to convert this so that it looks like this BR-1000-11. I tried - format- custom- ##-####-## but it does not work. HELP please thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dashes I want Dashes
Are all the same with TWO letters-four numbers-four characters.
-- Don Guillett Microsoft MVP Excel SalesAid Software "Marilyn" wrote in message ... Hello I have 3700 rows , Column A is alphanumeric e.g. BR100011. I need to convert this so that it looks like this BR-1000-11. I tried - format- custom- ##-####-## but it does not work. HELP please thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dashes I want Dashes
hi
forgot to add. ajust the cell address to fit your data. regards FSt1 "FSt1" wrote: hi If data is all the same length, do this add a column to the right of the data column and put this formula in =LEFT(I10,2) & "-" &MID(I10,3,4) & "-" & RIGHT(I10,2) copy down to as far as you need. the copy the formula column and pastespecial as values. delete the non-dash column. you got dashes regards FSt1 Re "Marilyn" wrote: Hello I have 3700 rows , Column A is alphanumeric e.g. BR100011. I need to convert this so that it looks like this BR-1000-11. I tried - format- custom- ##-####-## but it does not work. HELP please thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to remove dashes | Excel Worksheet Functions | |||
What are dashes for | Excel Discussion (Misc queries) | |||
Stripping the dashes | Excel Discussion (Misc queries) | |||
Dashes in my result | Excel Discussion (Misc queries) | |||
dashes in vlookup | Excel Worksheet Functions |