| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
combining column content
Thank you for all your help yesterday. After I combine the columns using
=B1&" "&C1, I have everything I need in column D. However, how do I then copy just the information to a new column without the formula?Then I can delete the combined columns and continue with the rest. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
combining column content
Hi,
If you have this formula in (say) D1 put =D1 in cell E1 Mike "Daphtg" wrote: Thank you for all your help yesterday. After I combine the columns using =B1&" "&C1, I have everything I need in column D. However, how do I then copy just the information to a new column without the formula?Then I can delete the combined columns and continue with the rest. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
combining column content
Ah, I think I now understand
Copy the cells that are concatenated and then select a new location and Edit|Paste Special - select 'Values' - OK Mike "Daphtg" wrote: Thank you for all your help yesterday. After I combine the columns using =B1&" "&C1, I have everything I need in column D. However, how do I then copy just the information to a new column without the formula?Then I can delete the combined columns and continue with the rest. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
combining column content
THANK YOU THANK YOU WOKS GREAT.
"Mike H" wrote: Ah, I think I now understand Copy the cells that are concatenated and then select a new location and Edit|Paste Special - select 'Values' - OK Mike "Daphtg" wrote: Thank you for all your help yesterday. After I combine the columns using =B1&" "&C1, I have everything I need in column D. However, how do I then copy just the information to a new column without the formula?Then I can delete the combined columns and continue with the rest. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| combining column content | Excel Worksheet Functions | |||
| Combining Content of two cells | Excel Discussion (Misc queries) | |||
| Combining Cell Content | Excel Discussion (Misc queries) | |||
| How to transpose formulas from column content to row content. | Excel Worksheet Functions | |||
| Combining cell contents when there is content to combine | Excel Discussion (Misc queries) | |||
Linear Mode
