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

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

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

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