| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine cells
I am trying to combine 5 txt columns into one column. example. column A-E
have txt fields and in column F I would like to combine all txt in columns A-E into one while leaving the original columns A-E the same. Please help! Thank you!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combine cells
Are you thinking of concatenate? "Junderwood57" wrote: I am trying to combine 5 txt columns into one column. example. column A-E have txt fields and in column F I would like to combine all txt in columns A-E into one while leaving the original columns A-E the same. Please help! Thank you!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combine cells
In F1, put
=A1&B1&C1&D1&E1 Or, if you want spaces between: =A1&" "&B1&" "&C1&" "&D1&" "&E1 Copy down column F as far as required. "Junderwood57" wrote in message ... I am trying to combine 5 txt columns into one column. example. column A-E have txt fields and in column F I would like to combine all txt in columns A-E into one while leaving the original columns A-E the same. Please help! Thank you!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine Cells | Excel Discussion (Misc queries) | |||
| Combine Cells | Excel Discussion (Misc queries) | |||
| Combine Cells | Excel Discussion (Misc queries) | |||
| Combine Cells | Excel Worksheet Functions | |||
| combine cells | Excel Discussion (Misc queries) | |||
Linear Mode
