Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Worksheet Functions > Concatenate group of cells
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 69
Default 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




Reply With QuoteReply With Quote
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 3,718
Default 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




Reply With QuoteReply With Quote
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 8,651
Default 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






Reply With QuoteReply With Quote
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 69
Default 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







Reply With QuoteReply With Quote
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 8,651
Default 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









Reply With QuoteReply With Quote
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 434
Default 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.


Reply With QuoteReply With Quote
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 5,934
Default 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








Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy Data from One Group of Cells to Another Group Alan Auerbach Charts and Charting in Excel 2 May 27th 07 04:12 PM
from a group of cells.find average of cells containing values farm Excel Discussion (Misc queries) 1 December 21st 06 08:50 PM
Concatenate cells Snakeoids Excel Discussion (Misc queries) 6 July 28th 06 01:46 PM
how do I UN-concatenate cells julia Excel Discussion (Misc queries) 2 January 5th 05 07:45 PM
copy group of cells to another group of cells using "IF" in third Chuckak Excel Worksheet Functions 2 November 10th 04 06:04 PM


All times are GMT +1. The time now is 05:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement