software

Hello,

In MSWord you are able to set the auto correct function to type in a
few lines of information when a certain letter or string of letters is
entered. Excel has this function but it is limited to one line(or at
least that is what i see).

Is there any way for me to just enter ABC and it display my company
address everytime i do so?

When i setup the autocorrect, all i get is the first line. Nothing
else.

Any ideas would be greatly appreciated.

Thank you very much
Joel--
joeldsmt
------------------------------------------------------------------------
joeldsmt's Profile: www.excelforum.com/member.php...oamp;userid=11889
View this thread: www.excelforum.com/showthread...hreadid=507371I don't think that this is autocorrect in MSWord--something like autotype???

Maybe you could use:

ABC replace with ABC$Company$whatever$you$want

Then let autocorrect change to the long on line text, then you could do
Edit|replace
what: $
with: ctrl-j
replace all

Use a character that's nice and unique so you don't quot;fixquot; the real $.

(or be very selective when you select your range.)joeldsmt wrote:
gt;
gt; Hello,
gt;
gt; In MSWord you are able to set the auto correct function to type in a
gt; few lines of information when a certain letter or string of letters is
gt; entered. Excel has this function but it is limited to one line(or at
gt; least that is what i see).
gt;
gt; Is there any way for me to just enter ABC and it display my company
gt; address everytime i do so?
gt;
gt; When i setup the autocorrect, all i get is the first line. Nothing
gt; else.
gt;
gt; Any ideas would be greatly appreciated.
gt;
gt; Thank you very much
gt; Joel
gt;
gt; --
gt; joeldsmt
gt; ------------------------------------------------------------------------
gt; joeldsmt's Profile: www.excelforum.com/member.php...oamp;userid=11889
gt; View this thread: www.excelforum.com/showthread...hreadid=507371

--

Dave Peterson


Will this automatically add the 4 lines of address that i want entered?

JM--
joeldsmt
------------------------------------------------------------------------
joeldsmt's Profile: www.excelforum.com/member.php...oamp;userid=11889
View this thread: www.excelforum.com/showthread...hreadid=507371Maybe...

It'll fill the cell with text that will wrap to 4 lines. Not 4 separate cells.
joeldsmt wrote:
gt;
gt; Will this automatically add the 4 lines of address that i want entered?
gt;
gt; JM
gt;
gt; --
gt; joeldsmt
gt; ------------------------------------------------------------------------
gt; joeldsmt's Profile: www.excelforum.com/member.php...oamp;userid=11889
gt; View this thread: www.excelforum.com/showthread...hreadid=507371

--

Dave Peterson


Thank you...

Will i be able to do this on any new spreadsheet or do i need to set it
up everytime?--
joeldsmt
------------------------------------------------------------------------
joeldsmt's Profile: www.excelforum.com/member.php...oamp;userid=11889
View this thread: www.excelforum.com/showthread...hreadid=507371If you use autocorrect, then it stays with the pc--but it'll be available for
all the workbooks that you open on that pc.
joeldsmt wrote:
gt;
gt; Thank you...
gt;
gt; Will i be able to do this on any new spreadsheet or do i need to set it
gt; up everytime?
gt;
gt; --
gt; joeldsmt
gt; ------------------------------------------------------------------------
gt; joeldsmt's Profile: www.excelforum.com/member.php...oamp;userid=11889
gt; View this thread: www.excelforum.com/showthread...hreadid=507371

--

Dave Peterson


I cant get this to work. I do appreciate your help but is there anyway
you can explain it a bit more?

Thank you in advance.--
joeldsmt
------------------------------------------------------------------------
joeldsmt's Profile: www.excelforum.com/member.php...oamp;userid=11889
View this thread: www.excelforum.com/showthread...hreadid=507371What part?

Did you get the entry added to the Autocorrect list?

Did the autocorrection actually take place?

Or was it the edit|replace that you had trouble with?

joeldsmt wrote:
gt;
gt; I cant get this to work. I do appreciate your help but is there anyway
gt; you can explain it a bit more?
gt;
gt; Thank you in advance.
gt;
gt; --
gt; joeldsmt
gt; ------------------------------------------------------------------------
gt; joeldsmt's Profile: www.excelforum.com/member.php...oamp;userid=11889
gt; View this thread: www.excelforum.com/showthread...hreadid=507371

--

Dave Peterson


It was the edit|replace part that i got lost.--
joeldsmt
------------------------------------------------------------------------
joeldsmt's Profile: www.excelforum.com/member.php...oamp;userid=11889
View this thread: www.excelforum.com/showthread...hreadid=507371Select your cells (at least two--even if one is empty).

Edit|replace
what: $ (or whatever character you used)
with: hit and hold the control key while hit the j key
click on Replace all

It may not look like anything went into that quot;withquot; box, but it you look close,
you'll see a difference--and try it--you'll see that it works.joeldsmt wrote:
gt;
gt; It was the edit|replace part that i got lost.
gt;
gt; --
gt; joeldsmt
gt; ------------------------------------------------------------------------
gt; joeldsmt's Profile: www.excelforum.com/member.php...oamp;userid=11889
gt; View this thread: www.excelforum.com/showthread...hreadid=507371

--

Dave Peterson