|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 21st, 2008, 06:31 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 
|
|
#2
September 21st, 2008, 06:39 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
|
#3
September 21st, 2008, 06:43 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
|
#4
September 21st, 2008, 07:00 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
|
#5
September 21st, 2008, 07:06 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
|
#6
September 22nd, 2008, 01:18 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.
|
|
#7
September 22nd, 2008, 05:02 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
