hey guys,
per the title, is there a way to do this through the interface? I can do it with VBA code but I think I would have to think too much about it. I tried to use SPLIT() with a delimiter, but that was only good for one cell. attached is a sample problem row I have:
I would even be will to accept a solution where I could get the 5 vertical cell values into 1 cell, separated by the semicolon ";" delimiter.
thanks!
I am confused. Why not use Textjoin? works perfectly for your example.
Formula for C1 =TEXTJOIN(,TRUE,B1:B5)
If you have multiple rows then use the indirect function to build your address for textjoin.
Formula for C1 then fill down. =TEXTJOIN(,TRUE,INDIRECT("B" & (ROW()-1)*5+1 &":B" & ROW()*5))
Finally Formula for C1 then fill down: =TEXTJOIN(CHAR(10),TRUE,INDIRECT("B" & (ROW()-1)*5+1 &":B" & ROW()*5)). Format Column C to Wrap Text.
Last edited by mehmetcik; 02-28-2020 at 01:15 AM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
I'm not sure why you're confused, Mehmetcik! I posted this because I'm no expert in excel. I'm a code writer and I know that excel has much more to offer than that. and your solution works perfectly. thanks so much sir! =)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks