- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Merging a column of data into one string in a cell
Posted on 10/3/14 at 12:28 pm
Posted on 10/3/14 at 12:28 pm
Say I have asset numbers in a column. I'm trying to get 80 of them into one string of data in a single cell. I've tried concatenate but I can't grab the whole group and do it this way, I'd have to select them one by one. I'm going to have to do this on a regular basis so I need an automated way to do it.
TIA
TIA
Posted on 10/3/14 at 1:00 pm to Brettesaurus Rex
Is this what you're talking about? LINK
Posted on 10/3/14 at 1:44 pm to TDawg1313
Holy mother of sorcery that's exactly what I needed
Posted on 10/3/14 at 3:00 pm to Brettesaurus Rex
Just to comment, if you are not using the "UDF" method described, your function does not "live" update. It's an interesting approach to the problem by pasting the values into the formula, and should work for one time uses.
Another way without using a macro, is to concatenate upon itself. And "drag" the formula down.
So if your info is in column A1:A80, in B1 "=A1". B2 "=Concatenate(B1, A2)". Now drag B2 down to B80.
B80 is now your fully concatenated string, and live updates.
It's the dirty way of doing it, but gets the job done another way.
Another way without using a macro, is to concatenate upon itself. And "drag" the formula down.
So if your info is in column A1:A80, in B1 "=A1". B2 "=Concatenate(B1, A2)". Now drag B2 down to B80.
B80 is now your fully concatenated string, and live updates.
It's the dirty way of doing it, but gets the job done another way.
Posted on 10/3/14 at 6:37 pm to LSUtigerME
Hey that will be a backup method, so thanks
Popular
Back to top
Follow TigerDroppings for LSU Football News