Letter spaced with DASH

**kuzna26** · 11-09-2013, 02:29 PM

Hey guys,
my problem insist:

I want input in cells A1:A10 letter and they must be spaced with dash

ie. AAABBBCCCDDD after i press the enter key it should show AAA-BBB-CCC-DDD

I have tried ###-###-###-### , it actually work with number only

Please any help
Thank you ,

Antonio

**alansidman** · 11-09-2013, 02:46 PM

You can't format Text using a format. You will need to put a formula in an adjacent column and do something like

(assume your first value is in A1, Then in B1 for example

=LEFT(A1,3)&"-"&MID(A1,4,3)&"-"&MID(A1,7,3)&"-"&RIGHT(A1,3)

now drag fill it down the column. Then select column B and do Edit=>Copy, then immediately Edit=>Paste Special and select Values. This will replace the formula with the values that are displayed. Then you can delete column A.

**Ghozi Alkatiri** · 11-09-2013, 06:06 PM

try this
=REPLACE(REPLACE(REPLACE(A1,4,0,"-"),8,0,"-"),12,0,"-")

**alansidman** · 11-10-2013, 07:40 PM

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.