How to copy and paste text after merging cell data??

[acegreen]

Hi, please help! This may be a basic question! I have merged the text contents of two cells, using formula such as A1&" "&B1 . This works fine. However when i click on the cell contents i see the formula. How can i now copy and/or export the merged text contents to a different sheet so i can upload them to a social distribution platform? Thank you in advance!!

 

[Marcílio_Lobão]

acegreen, Good morning.

You can Copy the merged content and Paste Special as Value.

Is this possible for you?

I hope it helps.

 

[acegreen]

acegreen, Good morning.

You can Copy the merged content and Paste Special as Value.

Is this possible for you?

I hope it helps.

Hello!! Thanks you.... you wonderful person! Problem sorted......that worked a treat, thank you from an excel novice!!

 

[Marcílio_Lobão]

You're welcome.

Thanks for the feedback.

Glad to help.