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!

Find more posts tagged with

Accepted answers

Mark Cronk

Hi @hcosta52671 ,

Try:

=Column1@row + " " + column2@row

Mark

hcosta52671

Perfect!!!

Exactly what I needed.

Thanks much.

Hugo

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.