| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge columns
I have 6 columns with 6 differents categories, I need to put them all in one
column. I went to CONCRENATE but couldn't do it. Can someone please help me? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Merge columns
Try CONCATENATE
Regards Trevor "wendy" wrote in message ... I have 6 columns with 6 differents categories, I need to put them all in one column. I went to CONCRENATE but couldn't do it. Can someone please help me? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Merge columns
Or try this
=A1&B1&C1&D1&E1&F1 "wendy" wrote: I have 6 columns with 6 differents categories, I need to put them all in one column. I went to CONCRENATE but couldn't do it. Can someone please help me? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Merge columns
=CONCATENATE(A1,B1,C1,D1,E1,F1) "wendy" wrote: I have 6 columns with 6 differents categories, I need to put them all in one column. I went to CONCRENATE but couldn't do it. Can someone please help me? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Merge columns
You are correct with the function..You can bring up to 30 strings together.
Be sure to press tab to get the next string to pop up for you past String 3. As well be sure to put a space between your categories by placing " " as a text string. For example =Concatenate(a1, " ", b1, " ", c1,etc.... "wendy" wrote: I have 6 columns with 6 differents categories, I need to put them all in one column. I went to CONCRENATE but couldn't do it. Can someone please help me? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Merge columns
=A1&" , "&B1&" , "&C1&" , "&D1&" , "&E1&" , "&F1
"wendy" wrote: I have 6 columns with 6 differents categories, I need to put them all in one column. I went to CONCRENATE but couldn't do it. Can someone please help me? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to merge columns | Excel Worksheet Functions | |||
| merge columns e with f into e. | New Users to Excel | |||
| merge text from 2 columns into 1 then delete the old 2 columns | Excel Worksheet Functions | |||
| I want to merge two columns | New Users to Excel | |||
| How to merge columns | Excel Worksheet Functions | |||
Linear Mode
