I want to build a Comma Delimited String from a range of cells. I know I could use the concatenate function, but sometimes I want to add 100's of cells.
What is a macro that would build a string of cells separated by a comma! It would also be nice to add a string to the beginning and end of the cells.
g
Perhaps,
http://www.automateexcel.com/2005/10...ted_text_file/
would do?
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Maybe like so:
Please Login or Register to view this content.
Last edited by JBeaucaire; 12-03-2010 at 11:05 AM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
JB,Originally Posted by JBeaucaire
I like this option. Let me ask you if there is away to modify this so that I could put another field next to the range and use that as a number field to determine a number to filter on. Say for example the extra column would have 1 thru 9 and if I wanted to do a delimited string for the rows with a 3 in the 2nd column?
Does this make sense?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks