Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining text cells.
Can anyone tell me how to combine a group of text cells into one cell for the
purpose of referencing them in a formula later? Any help is greatly appreciated! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining text cells.
Try this
Put your first name in A1 and your last name in B1 =CONCATENATE(A1,B1) This one will add a comma between cells =CONCATENATE(A1,",",B1) "johnnyz197034" wrote: Can anyone tell me how to combine a group of text cells into one cell for the purpose of referencing them in a formula later? Any help is greatly appreciated! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining text cells.
One way:
=A1 & A2 & A3 If you want to do it without formulae, take a look he http://www.mcgimpsey.com/excel/subs/mergedata.html In article , johnnyz197034 wrote: Can anyone tell me how to combine a group of text cells into one cell for the purpose of referencing them in a formula later? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining text from different Cells IF | Excel Discussion (Misc queries) | |||
combining text & number from different cells | Excel Discussion (Misc queries) | |||
Working with Random Text & Combining Cells | Excel Discussion (Misc queries) | |||
combining text from 2 cells | Excel Discussion (Misc queries) | |||
Combining Text and numbers from two cells | Excel Discussion (Misc queries) |