Posted to microsoft.public.excel.worksheet.functions
|
|
Inserting a hyphen after the 3rd character
Harlan,
I think that you may have meant:
=REPLACE(A1,4,0,"-")
to insert the hyphen after the third character not the second.
--
Regards,
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Harlan Grove" wrote in message
...
Pete_UK wrote...
One way:
=LEFT(A1,3)&"-"&RIGHT(A1,LEN(A1)-3))
...
Shorter, simpler, more efficient to use
=REPLACE(A1,3,0,"-")
|