How to store the result of a formula in new cell

samcharles

New member
Joined
Oct 14, 2011
Messages
2
Reaction score
0
Points
0
Hi

I have values 200 values in Column A
I have values 200 values in Column B

Column C has the concatenation formula:

=CONCATENATE(A1,"+",B1)

I want only the result of the Column C in Column D not the forrmula for my further programs.

pls help
 
Select Column C

Copy - Ctrl-C

Home>Paste>Paste Values
 
I dont want to do this manually. I want something to be dynamic that column C and Column D should be changed as the values in the column A and B changes.
I want only the formula result in the column D. pls help.
 
Can you give some idea on how you're using this? You can use the results of the formula in any calculation and any export to text will send just the values. It's unclear why you would need this functionality. It's certainly possible with VBA code.

Jesse
 
If you don't want to do it manually, I think you'll need to use VBA. Here is a UDF using VBA which might help...

http://www.vbaexpress.com/kb/getarticle.php?kb_id=62

This does of course assume that you have the actual formula in a cell somewhere. I'm not sure if this would be in column D or not, your post is a little cryptic. But if you have the formula =A1+B1 in cell D1, then you can use this UDF in C1 and enter the formula =FTEXT(D1). Instructions to use the code are in the link as well.

HTH
 
Back
Top