Start Free Trial
Log in
Gareth_Pointon
asked on
Excel Formula
Is there a formula I can use to convert row A to display as in row B ?
ASKER CERTIFIED SOLUTION
Phillip Burton
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
How it works
Start Free Trial
Rgonzo1971
Hi,
Maybe
=IF(LEN(A2)>10,LEFT(A2,8)&
"-"&RIGHT(
A2,2),A2)
Regards
Maybe
=IF(LEN(A2)>10,LEFT(A2,8)&
Regards