LinkBack URL
About LinkBacks
I have a table with several rows with independent data in each cell which sometimes have blanks. I need to concatenate this data into one cell. How do I do this? I am lost!
Example Table:
IN1002-001 000 LSE 1031196 001 IN1002-002 000 LSE FEE 1031197
Concatenate all cells in a row leaving out blanks
I have a table with several rows with independent data in each cell which sometimes have blanks. I need to concatenate this data into one cell. How do I do this? I am lost!
Example Table:
IN1002-001 000 LSE 1031196 001 IN1002-002 000 LSE FEE 1031197
The blanks do not matter do they?
Formula:
Please Login or Register to view this content.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
haha that was way too easy. I am struggling today.
THANKS!!!
Can you mark the thread as solved?
Also you dont NEED to have the concatenate formula, you can just use:
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks