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?
--
Thanks,,
Kim

Kim,

You could put in an autocorrect entry (ToolsAutocorrect) 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)


"Kim K" wrote in message
...
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?
--
Thanks,,
Kim

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...)

Bob Phillips wrote:

Kim,

You could put in an autocorrect entry (ToolsAutocorrect) 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)

"Kim K" wrote in message
...
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?
--
Thanks,,
Kim

--

Dave Peterson