copy data from cell with formula

[mnhim001]

How do I copy a cell with a formula in it, but only want the results from the formula?

My A1 looks like this in the formula bar =CONCATENATE(D:D,", ",B:B," ",C:C)

But, whats displayed is Doe, John H.

I want to copy the displayed, not the formula.

 

[VoG]

Copy then use Edit > Paste Special, tick Values then click OK.

 

[mnhim001]

oh...sorry never noticed the paste special before. always did the keyboard shortcut.

 

[Yahya]

oh...sorry never noticed the paste special before. always did the keyboard shortcut.

you can also use shortcut
Ctrl+C = Copy
Ctrl+Alt+V -> v = paste Special Values