I have column of product codes that I need to insert into a field in my shopping cart. There are about 600 of them and the text in each field needs to be separated by commas.
I thought Concatenate may be a good idea, but that's a heck of a lot of clicking. haha
Does anyone know how I can join the text in all the cells into one field that is comma delimited.
To illustrate:
Column A
EC-001
EC-002
EC-003
EC-004
EC-005
What I need is data joined too look like this:
EC-001,EC-002,EC-003,EC004,EC-005
But there are like 650 of them. Literally.
Any ideas?
I've gotten a lot of help from this forum for free. And I don't take that lightly.
Thanks.
Nick
Assuming the list starts in A1:
In B1 enter: =A1
In B2 enter: =B1&","&A2 and copy down
The last cell will contain your concatenated list of values which you can then copy...paste special...values.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Assuming the list starts in A1:
In B1 enter: =A1
In B2 enter: =B1&","&A2 and copy down
The last cell will contain your concatenated list of values which you can then copy...paste special...values.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks