How do I show cell data as a value when referencing another cell that includes a formula?

I want to show a cell value in a cell where it is being referenced to a cell that includes a simple formula e.g.

In D4 I want to reference C4 (i.e. =C4) and show it as a value, where C4 has a concatenate formula: =concatenate("000",A4,"-",E4,"-",J4,"-",M4).


Category: microsoft excel Time: 2016-07-29 Views: 0

Related post

iOS development

Android development

Python development

JAVA development

Development language

PHP development

Ruby development


Front-end development


development tools

Open Platform

Javascript development

.NET development

cloud computing


Copyright (C), All Rights Reserved.

processed in 0.116 (s). 12 q(s)