Using "&" function for multiple cells

**L.LEE** · 07-26-2016, 11:31 PM

Hi

I would like to have a formula that is =a1&a2.......a100. Is there a shortcut or do I need to manually key in the whole string?

thanks

**Tony Valko** · 07-27-2016, 12:34 AM

If using a built-in formula syntax you have to type each cell reference.

If you are able/open to using a VBA function it could be much shorter.

**L.LEE** · 07-27-2016, 12:35 AM

thanks for your explanation

**Tony Valko** · 07-27-2016, 12:38 AM

You're welcome!

**MarvinP** · 07-27-2016, 12:42 AM

Hi L.Lee,

I think you are looking for the Concat() function. Specifically "=CONCAT(A1:A100)"
See an example in the attached.
Concat Range of Cells.xlsx

**Tony Valko** · 07-27-2016, 12:54 AM

Note that the CONCAT function requires Excel 2016.

Using "&" function for multiple cells

LinkBack

Thread Tools

Rate This Thread

Display

Using "&" function for multiple cells

Re: Using "&" function for multiple cells

Re: Using "&" function for multiple cells

Re: Using "&" function for multiple cells

Re: Using "&" function for multiple cells

Re: Using "&" function for multiple cells

Thread Information

Users Browsing this Thread

Similar Threads

How to check if a range of cells contains the word "unresponsive" and return "yes" or "no"

Using "if" function to look for strings containing a specific text, in multiple cells

[SOLVED] Formula Needed to fill multiple cells with "No" when the word "No" is entered into a cell

[SOLVED] How to USE """"" cells count """"" change font color

Pivot Table - How to "add a data column" "of the same field" "across multiple sheets"

[SOLVED] "If" function with Multiple Ref Cells in Text and Return Value

[SOLVED] Data validation: allow entry into a cell if other three cells have "X", "Y" and "Z"?

Change "Parent" cell based on results of multiple "Children" cells

Bookmarks

Bookmarks

Posting Permissions