Combining Cells-how do I combine the results of 3 columns

**eyeball11** · 06-22-2010, 03:38 PM

Probably an extremely stupid question but how do I combine the results of 3 columns? For example in A1 I have 2071000, in B1 I have / and in C1 I have A.

End result should be 2071000 / A.

**Ron Coderre** · 06-22-2010, 03:40 PM

Try this:

D1: =A1&B1&C1

Does that help?

**eyeball11** · 06-22-2010, 03:44 PM

Originally Posted by Ron Coderre

Try this:

D1: =A1&B1&C1

Does that help?

For the love of God!! I had the same thing but had VALUE outside brackets of your formula.

Thanks and sorry for being an idiot!!

**zbor** · 06-22-2010, 03:40 PM

Try =CONCATENATE(A1, B1, C1)

but if you want them separate you'll need:

=CONCATENATE(A1, " ", B1, " ", C1)

Combining Cells-how do I combine the results of 3 columns

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Combining Cells-how do I combine the results of 3 columns

re: Combining Cells-how do I combine the results of 3 columns

re: Combining Cells-how do I combine the results of 3 columns

re: Combining Cells-how do I combine the results of 3 columns

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions