Auto copy info from one cell to another.
I use a very simple formula, "=Name1".
The formula is in Column 2 of the sheet and it is a hidden column.
When the user enters text in Column 1, that text is automatically copied to Column 2 because of that formula.
This works fine for me. Now, what I want to do is pretty much the same, but combine info from 2 columns.
Column 1 is called "Color"
Column 2 is called "Animal"
Column 3 would be the result column.
So, I need a formula that if "Brown" is entered in Column 1 and "Bear" is entered in Column 2, then Column 3 would auto fill with "Brown Bear".
I'd appreciate any help or ideas the community may have.
Help Article Resources
Check out the Formula Handbook template!