| 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) | |||
Linear Mode
