I'm trying to concatenate two cells, but I want the destination cell to be the same as the cell that I'm pulling some of my values from, for instance, I want to combine cells A1 and B1, and I want the destination cell for the formula to be A1. Is this possible?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
destination cell same as value
- Thread starter xenophone
- Start date
Rick Rothstein
MrExcel MVP
- Joined
- Apr 18, 2011
- Messages
- 38,330
- Office Version
- 365
- Platform
- Windows
A cell can contain either a value or a formula, but not both at the same time. Think about it... how would that work? You have a value in a cell... as soon as you enter the formula, it would overwrite (replace) the value; on the other hand, if you had a formula in a cell and entered a value, same problem, the value would overwrite (replace) the formula. Excel has lots of cells available... just put your formula in, say, Column C... a value in A and one in B would be added evaluate and the calculation placed in C. Or are you trying to accumulate values as they are entered in a cell? If that is what you want to do, then you will need VB event code to manage the accumulation; but just keep in mind, doing that will leave no audit trail so if a user enters a wrong number, there will be no way to find the mistake.
Upvote
0
mikerickson
MrExcel MVP
- Joined
- Jan 15, 2007
- Messages
- 24,351
That cannot be done by putting a formula in column A cells.
You could have a helper column with the appropriate formula and then copy/paste values that column into column A.
You could have a helper column with the appropriate formula and then copy/paste values that column into column A.
Upvote
0
The values in column A aren't from a formula. I don't care where I put the formula, but I need to keep all of the values in column A in column A after they're changed.
I'm trying to append some website URLs. The original URL's in column A would look like:
www.website.com/index2.epl <----- I have thousands of these URLs and they're all unique.
Date to append is: &ad={creative} <----- I need to add this to the end of every value in column A, so after appending to the above value, it would look like:
www.website.com/index2.epl&ad={creative}
I may be conflating "value" and "text". If those have specific definitions in excel than I might be using those terms incorrectly.
I'm trying to append some website URLs. The original URL's in column A would look like:
www.website.com/index2.epl <----- I have thousands of these URLs and they're all unique.
Date to append is: &ad={creative} <----- I need to add this to the end of every value in column A, so after appending to the above value, it would look like:
www.website.com/index2.epl&ad={creative}
I may be conflating "value" and "text". If those have specific definitions in excel than I might be using those terms incorrectly.
Upvote
0
Similar threads
- Solved
