Inserting a hyphen after the 3rd character
One way:
=LEFT(A1,3)&"-"&RIGHT(A1,LEN(A1)-3))
Hope this helps.
Pete
On Oct 29, 6:42*pm, wrote:
Hi All,
I am looking for a way to insert a hyphen (-) in a cell after the
third character. For example,
123456789 turns into 123-456789. Any ideas? Thanks in advance!!! *Jen
|