Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Combining multiple columns of text
I have a file of addresses. Each individual line of the address is in a
different adjacent cell. I would like to be able to combine the text into one cell that is separated by commas, and or spaces. Is there an easy way to achieve this -- Amber |
#2
|
|||
|
|||
Are you making labels?
If yes, then keep your data the way it is. It's much easier to combine the values than to separate it. Use excel as your data base and use MSWord as the application to make the mailing labels. You may want to read some tips for mailmerge. http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMerge The first is from David McRitchie and the second is by Beth Melton and Dave Rado. Amber Schellenberg wrote: I have a file of addresses. Each individual line of the address is in a different adjacent cell. I would like to be able to combine the text into one cell that is separated by commas, and or spaces. Is there an easy way to achieve this -- Amber -- Dave Peterson |
#3
|
|||
|
|||
Yes. You can combine text from different cells into a single cell.
For example, if A1 contains Springfield and A2 contains Ohio then =A1&", "&A2 in a cell would result in Springfield, Ohio -- Gary''s Student "Amber Schellenberg" wrote: I have a file of addresses. Each individual line of the address is in a different adjacent cell. I would like to be able to combine the text into one cell that is separated by commas, and or spaces. Is there an easy way to achieve this -- Amber |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining text from multiple columns into 1 | Excel Discussion (Misc queries) | |||
Connect multiple columns in 1 row to another? | New Users to Excel | |||
Text to columns will not shut off. | Excel Worksheet Functions | |||
Why text to columns is not available when there is mulipule line . | Excel Worksheet Functions | |||
splitting text to multiple columns | Excel Discussion (Misc queries) |