Help!!! i'm really failing on this matter.
I need All Text in column B2 that contains abc, to be copied separeted with commas to column D3.
Can this be done? Thanks in Advance!!!!
Help!!! i'm really failing on this matter.
I need All Text in column B2 that contains abc, to be copied separeted with commas to column D3.
Can this be done? Thanks in Advance!!!!
Hi
You didnt attach any file....
Sorry, my bad!
https://docs.google.com/spreadsheets...it?usp=sharing
Can you update your Profile with your Excel version as I am sure it is not 2001!
https://docs.google.com/spreadsheets...it?usp=sharing
I uploaded to Drive since im not being able to attach files... not my day,,,
Thanks, and what do you mean separated by commas?
can you give an example?
7862.0.jpg,
7862.1.jpg,
7862.2.jpg,
Like this. I made one by hand, but im looking for a formula in order to save time.
How aboutFormula:=TEXTJOIN(", ",1,if(left($B$2:$B$140,6)=A2,$B$2:$B$140,""))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks