text formula

K

Kim K

I am trying to create a workbook and alot of my data is repeating data such
as email addresses. I have done this before but forgot how, I want to create
a formula that all I have to do is type in the name and the @xxx.ccc.vvv.com
will automatically add itself to what I type in the cell. Can someone
refresh my memory on how this is done?
 
B

Bob Phillips

Kim,

You could put in an autocorrect entry (Tools>Autocorrect) for @ of
@xxx.ccc.vvv.com, and when you type @ and Enter, it will append the rest.
But it will do it for all @ wherever you may enter them.


--

HTH

RP
(remove nothere from the email address if mailing direct)
 
D

Dave Peterson

Or even a string that isn't likely to occur in the data.

maybe autocorrecting @@ to @xxx.ccc.vvv.com

would be a little more conservative.

And to the OP, remember that autocorrection entries are shared across the
MSOffice Suite of appliacations (Word/excel/powerpoint...)
 
Top