Find/Replace

[Scottmk]

--------------------------------------------------------------------------------

Hi,

I often refer to the following number format in emails: (XXX-XXXXXX). The first three numbers in each string need to be replaced with a prefix (there are currently about 10 different prefixes in use. I would like to change the prefix to a Letter. For example, I would like to replace 123-456789 with A-456789 and I would like to switch 234-567891 with B-567891 etc.

Is there a code I could employ to automatically swap out the first three numbers for the letter whenever entered in an email? Thanks.

[NBVC]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.

Please choose 1 forum... the correct forum for your question.. and post only once.