Concatenate group of cells
 

Is it possible to concatenate group of cells. i e for exp if cell a1
contains "a" and cell a28 contains "z" . What i want is a formula which will
results in to abcd----xyz.

Harshawardhan . Shastri

India

Concatenate group of cells
 

Download and install the free add-in Morefunc.xll from:
http://xcell05.free.fr/

then use this formula

=MCONCAT(IF(A1:A28<"",A1:A28))



"HARSHAWARDHAN. S .SHASTRI" wrote:

Is it possible to concatenate group of cells. i e for exp if cell a1
contains "a" and cell a28 contains "z" . What i want is a formula which will
results in to abcd----xyz.

Harshawardhan . Shastri

India

Concatenate group of cells
 

=A1&A2&A3&A4&A5&A6&A7&A8&A9&A10&A11&A12&A13&A14&A1 5&A16&A17&A18&A19&A20&A21&A22&A23&A24&A25&A26&A27& A28

--
David Biddulph

"HARSHAWARDHAN. S .SHASTRI"
wrote in message
...
Is it possible to concatenate group of cells. i e for exp if cell a1
contains "a" and cell a28 contains "z" . What i want is a formula which
will
results in to abcd----xyz.

Harshawardhan . Shastri

India

Concatenate group of cells
 

Sorry David,

This type of formula i was not expecting from you.Looking for "SMART"
formula.

Harshawardhan.Shastri

================================================== ========

"David Biddulph" wrote:

=A1&A2&A3&A4&A5&A6&A7&A8&A9&A10&A11&A12&A13&A14&A1 5&A16&A17&A18&A19&A20&A21&A22&A23&A24&A25&A26&A27& A28

--
David Biddulph

"HARSHAWARDHAN. S .SHASTRI"
wrote in message
...
Is it possible to concatenate group of cells. i e for exp if cell a1
contains "a" and cell a28 contains "z" . What i want is a formula which
will
results in to abcd----xyz.

Harshawardhan . Shastri

India

Concatenate group of cells
 

I will look forward to seeing a "smarter" formula which doesn't use VBA or
add-ins.
--
David Biddulph

"HARSHAWARDHAN. S .SHASTRI"
wrote in message
...
Sorry David,

This type of formula i was not expecting from you.Looking for "SMART"
formula.

Harshawardhan.Shastri

================================================== ========

"David Biddulph" wrote:

=A1&A2&A3&A4&A5&A6&A7&A8&A9&A10&A11&A12&A13&A14&A1 5&A16&A17&A18&A19&A20&A21&A22&A23&A24&A25&A26&A27& A28

--
David Biddulph

"HARSHAWARDHAN. S .SHASTRI"
wrote in message
...
Is it possible to concatenate group of cells. i e for exp if cell a1
contains "a" and cell a28 contains "z" . What i want is a formula which
will
results in to abcd----xyz.

Harshawardhan . Shastri

India

Concatenate group of cells
 

hi, Harshawardhan.Shastri !

... Looking for "SMART" formula...

do you speak/read spanish ?

- have a look he
http://www.teladearana.es/seccion/excel/107-h11.html
download a sample workbook (spanish comments) here
http://www.teladearana.es/descargas....fileinfo&id=18

hth,
hector.

Concatenate group of cells
 

I'm not sure I completely understand your requirement, but let me take a
guess. Does this formula do what you want?

=MID("abcdefghijklmnopqrstuvwxyz",CODE(A1)-96,CODE(A28)-CODE(A1)+1)

--
Rick (MVP - Excel)


"HARSHAWARDHAN. S .SHASTRI"
wrote in message
...
Sorry David,

This type of formula i was not expecting from you.Looking for "SMART"
formula.

Harshawardhan.Shastri

================================================== ========

"David Biddulph" wrote:

=A1&A2&A3&A4&A5&A6&A7&A8&A9&A10&A11&A12&A13&A14&A1 5&A16&A17&A18&A19&A20&A21&A22&A23&A24&A25&A26&A27& A28

--
David Biddulph

"HARSHAWARDHAN. S .SHASTRI"
wrote in message
...
Is it possible to concatenate group of cells. i e for exp if cell a1
contains "a" and cell a28 contains "z" . What i want is a formula which
will
results in to abcd----xyz.

Harshawardhan . Shastri

India