You are aware that a cell can take in limited number of characters. Any more
than that number, the result will be truncated please.

"mj44" wrote in message
...
I have a spreadsheet using 3 columns and n number of rows worth of data.
I
am trying to create one long string of this data by concatenating in the
following order:

A1,B1,C1,A2,B2,C2,A3,B3,C3, etc.

The only way I know how to do a large range is to individually click on
each
cell and that will take a very long time.

Is there an easy way to concatenate a range such as (A1:C500)?

Thank you.