Inserting a hyphen after the 3rd character

P

pjamorton

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
 
S

Sandy Mann

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top