May 11 2023 06:10 AM
Hello,
Back here again after seeing how fast the last issue of mine got solved. This time around i am wondering IF there is any way(i am willing to try VBA if needed) to bring the text from a range of cells in a column to a desired(always the same) format. I am bringing data(text and values) from different files that are basically saying the same thing but in another format to a main file that I later have to pivot so I can extract the values. Is there any way to format directly the B column to the same text?something like: if b2 contains "Jason" or "statham"=> "Jason Statham" but for multiple(water, milk, office chair, etc. ...)conditions?
Thank you in advance!
May 12 2023 07:42 PM
May 14 2023 10:54 PM - edited May 14 2023 10:56 PM
Hello!
Thank you for your answer. Maybe I overcomplicated the issue a little and even posted a wrong picture of what i am trying to achieve. The point is that I always bring columns from other sets of data that contains miss-spelled words(maybe shortcuts too). Given this, I have to replace all the missplaced letters manually(sometimes even delete some)only so the NEW column matches the existing one otherwise when creating a pivot-table later on it would create a new position instead of adding the value to the original one.