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: http://www.excelforum.com/member.php...o&userid=11889
View this thread: http://www.excelforum.com/showthread...hreadid=507371

I 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 "fix" the real $.

(or be very selective when you select your range.)


joeldsmt wrote:

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: http://www.excelforum.com/member.php...o&userid=11889
View this thread: http://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: http://www.excelforum.com/member.php...o&userid=11889
View this thread: http://www.excelforum.com/showthread...hreadid=507371

Maybe...

It'll fill the cell with text that will wrap to 4 lines. Not 4 separate cells.



joeldsmt wrote:

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

JM

--
joeldsmt
------------------------------------------------------------------------
joeldsmt's Profile: http://www.excelforum.com/member.php...o&userid=11889
View this thread: http://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: http://www.excelforum.com/member.php...o&userid=11889
View this thread: http://www.excelforum.com/showthread...hreadid=507371

If 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:

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: http://www.excelforum.com/member.php...o&userid=11889
View this thread: http://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: http://www.excelforum.com/member.php...o&userid=11889
View this thread: http://www.excelforum.com/showthread...hreadid=507371

What 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:

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: http://www.excelforum.com/member.php...o&userid=11889
View this thread: http://www.excelforum.com/showthread...hreadid=507371

--

Dave Peterson

It was the edit|replace part that i got lost.


--
joeldsmt
------------------------------------------------------------------------
joeldsmt's Profile: http://www.excelforum.com/member.php...o&userid=11889
View this thread: http://www.excelforum.com/showthread...hreadid=507371

Select 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 "with" box, but it you look close,
you'll see a difference--and try it--you'll see that it works.


joeldsmt wrote:

It was the edit|replace part that i got lost.

--
joeldsmt
------------------------------------------------------------------------
joeldsmt's Profile: http://www.excelforum.com/member.php...o&userid=11889
View this thread: http://www.excelforum.com/showthread...hreadid=507371

--

Dave Peterson

That worked. Thank you Dave.


--
joeldsmt
------------------------------------------------------------------------
joeldsmt's Profile: http://www.excelforum.com/member.php...o&userid=11889
View this thread: http://www.excelforum.com/showthread...hreadid=507371