Forum Discussion
BRINGING CELLS TO SAME TEXT FORMAT
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 ...
1 f you have range of data with COLUMN A and B somewhere, you can try VLOOKUP.
2 The range of data must contain two columns of FORMAT YOU HAVE and DESIRED TEXT, then only it can find out.
3. We don't know the values for the above two columns like what are the keywords you have and how you want them, in DESIRED TEXT column.
2 The range of data must contain two columns of FORMAT YOU HAVE and DESIRED TEXT, then only it can find out.
3. We don't know the values for the above two columns like what are the keywords you have and how you want them, in DESIRED TEXT column.
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.