F
fitzu
I need to add a - after the first 5 digits can get it to work with numbers
but not with letters & numbers
but not with letters & numbers
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gary''s Student
Try:
=LEFT(A1,5) & "-" & RIGHT(A1,LEN(A1)-5)
=LEFT(A1,5) & "-" & RIGHT(A1,LEN(A1)-5)
D
daddylonglegs
Hi Fitzu, try this
=REPLACE(A1,6,0,"-")
=REPLACE(A1,6,0,"-")
C
Cruz
Gary''s Student said:Try:
=LEFT(A1,5) & "-" & RIGHT(A1,LEN(A1)-5)
Hey How abt if I want to do the other way round, get rid of the dash"-" in
between?
G
Gord Dibben
Edit>Replace
What: -
With: nothing
Gord Dibben MS Excel MVP
What: -
With: nothing
Gord Dibben MS Excel MVP
F
fitzu
fitzu said:I need to add a - after the first 5 digits can get it to work with numbers
but not with letters & numbers
I have tried both sugestion but i could no get it to work if i did as
formula got an error if i tried in formatting did not work . for numbers only
I used #####"-"##### is there a wildcard i could use instead for letters or
am i inputing the formulas in to the wrong area
D
daddylonglegs
I don't think you can achieve this with formatting, my formula
suggestion above involves using that formula in another cell
suggestion above involves using that formula in another cell