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