Adding a count to concatenate range function

**mbus** · 02-12-2013, 09:03 PM

Hi all,

I am looking to alter current coding in a concatenaterange function. See below:

Please Login or Register  to view this content.

Within the workbook I use CHAR(10) as a separator however I want the function to count the total cells to be concatenated in the range and attribute a separator such as 1) Cell Detail 1, 2) Cell Detail 2, etc. For example if I had the following data in each cell:
A1: Thanks
A2: for the
A3: help!

I want it to look like:

B1: 1) Thanks
2) for the
3) help!

Thanks in advance!
- mbus

**mbus** · 02-12-2013, 10:45 PM

I am desperate!

**jindon** · 02-12-2013, 10:50 PM

You need to wrap the code with the code tag.
i.e
[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]

It is a MUST rule here.

**mbus** · 02-12-2013, 11:05 PM

Apologies, I am very green to these forums. Thanks.

Please Login or Register  to view this content.

**nilem** · 02-12-2013, 11:08 PM

for example

Please Login or Register  to view this content.

**jindon** · 02-12-2013, 11:12 PM

Thanks for the code tag and I hope you can edit your first post as well.

Here's an idea

Please Login or Register  to view this content.

**mbus** · 02-12-2013, 11:17 PM

Jindon, you are a life saver. It works perfectly thank you! +rep!

**jindon** · 02-12-2013, 11:18 PM

You are welcome and thanks for the edit.

Adding a count to concatenate range function

LinkBack

Thread Tools

Rate This Thread

Display

Adding a count to concatenate range function

Re: Adding a count to concatenate range function

Re: Adding a count to concatenate range function

Re: Adding a count to concatenate range function

Re: Adding a count to concatenate range function

Re: Adding a count to concatenate range function

Re: Adding a count to concatenate range function

Re: Adding a count to concatenate range function

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions