Auto copy info from one cell to another.

hcosta52671

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.

Example:

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.

Thanks!

Mark Cronk

Hi @hcosta52671 ,

Try:

=Column1@row + " " + column2@row

Mark

hcosta52671

Perfect!!!

Exactly what I needed.

Thanks much.

Hugo

Mark Cronk

Hi @hcosta52671 ,

Try:

=Column1@row + " " + column2@row

Mark

hcosta52671

Perfect!!!

Exactly what I needed.

Thanks much.

Hugo

Mark Cronk

Happy yo help. Thank you for using the Community.

Mark