Thread
:
How do I condense several cells to make address labels?
View Single Post
#
4
Posted to microsoft.public.excel.misc
Posts: n/a
How do I condense several cells to make address labels?
Hi
It should show up immediately - if you have calculation set to Automatic
(see Tools/Options/Calculation)
Andy.
"Jen" wrote in message
...
"Stephen" wrote:
"CONCATENATE Excel function" <CONCATENATE Excel
wrote in message
...
I cannot seem to figure out the CONCATENATE function. I have an enormous
amount of info. on a spreadsheet, from which I would like to
extrapolate
information to make a address label database. How do I do this?
CONCATENATE simply joins the text from two (or more) cells. For example,
with "qwe" in A1 and "rty" in B1,
=CONCATENATE(A1,B1)
will give "qwerty".
However, it's a redundant function since the much simler formula
=A1&B1
does the same thing.
Thank you very much..it's the first time I use this function:-)))
Just one more question, does the result of this formula show up right away
or do I have to do soemthing else?
Reply With Quote