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
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,942
Reaction score
0
Points
36
Excel Version(s)
O365
Select Column C

Copy - Ctrl-C

Home>Paste>Paste Values
 

samcharles

New member
Joined
Oct 14, 2011
Messages
2
Reaction score
0
Points
0
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.
 

Jesse

New member
Joined
Mar 22, 2011
Messages
51
Reaction score
0
Points
0
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
 

Zack Barresse

Super Moderator
Staff member
Joined
Mar 16, 2011
Messages
112
Reaction score
0
Points
0
Location
Oregon, United States
Excel Version(s)
365, Online, iOS, iOS for iPad
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
 
Top