| Home |
| Search |
| Today's Posts |
|
#7
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 | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Data from One Group of Cells to Another Group | Charts and Charting in Excel | |||
| from a group of cells.find average of cells containing values | Excel Discussion (Misc queries) | |||
| Concatenate cells | Excel Discussion (Misc queries) | |||
| how do I UN-concatenate cells | Excel Discussion (Misc queries) | |||
| copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions | |||
Threaded Mode
