S
Sandy
I am trying to create a formulae to do the following:
postal code: L1T3H-7
should be
L1T 3H7
can anyone help me out.
postal code: L1T3H-7
should be
L1T 3H7
can anyone help me out.
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.
C
Chip Pearson
Sandy,
Try the following formula:
=LEFT(SUBSTITUTE(A1,"-",""),3)&" "&RIGHT(SUBSTITUTE(A1,"-",""),3)
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
Try the following formula:
=LEFT(SUBSTITUTE(A1,"-",""),3)&" "&RIGHT(SUBSTITUTE(A1,"-",""),3)
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
E
Eric
Sandy,
Here's one way. I left your original text in cell A1 and
put the following formula in cell B1:
=LEFT(A1,3)&" "&SUBSTITUTE(RIGHT(A1,4),"-","")
HTH
Eric
Here's one way. I left your original text in cell A1 and
put the following formula in cell B1:
=LEFT(A1,3)&" "&SUBSTITUTE(RIGHT(A1,4),"-","")
HTH
Eric
S
Sandy
Chip your are the greatest!!!!!!!!!!!!!!!!!!!!!!!!!11
G
Gerry Kuta
=SUBSTITUTE(A1,"-","")+0 to remove the - ...then you can
use
=REPLACE(A1,4,,"") to split it (within one cell)
Place these in the cells you need them to be in.
HRH
use
=REPLACE(A1,4,,"") to split it (within one cell)
Place these in the cells you need them to be in.
HRH
P
Peo Sjoblom
=SUBSTITUTE(SUBSTITUTE(A1,MID(A1,3,1),MID(A1,3,1)&" "),"-","")
With the post code in A1
With the post code in A1