| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I merge two columns containing text in excel?
Is it possible to merge 2 lists on excel ie 2 colmns of text into one column?
Thanks Trissie |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I merge two columns containing text in excel?
Use a third column, with the formula =B8&C8
If you want a space between the two use =B8&" "&C8 "Trissie" wrote: Is it possible to merge 2 lists on excel ie 2 colmns of text into one column? Thanks Trissie |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I merge two columns containing text in excel?
This is typically pretty easy to manipulate in any way that you want.
If you need more than two columns or a guide to walk you through it, just look for the function 'concatenate" by clicking the fx in the formula bar or by going Insert-function. This will walk you through how to use the formula and will make sure that the syntax is correct. -Brian |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I merge 4 excel columns to 1 column (street,city,st,zip | Excel Discussion (Misc queries) | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| Excel 2002 : How to segregate text into columns ? | Excel Discussion (Misc queries) | |||
| Convert Text to Columns with Excel 2007 beta does not work well | Excel Worksheet Functions | |||
| Excel text to columns | Excel Discussion (Misc queries) | |||
Linear Mode
