Please see attached file for sample. So, what I'd like to see is in ColA, I have existing data, and I'd like to loop thru and achieved like the Result in ColB, but without dump the data in another column. So, the existing text in ColA, loops thru that entire column, concatenate word 'Equipment', adding single quotes ('Samsung Equipment') like so around the text. Hope this helps and makes sense.
Reply With Quote
