Hello, I'm looking to do a find and replace and simplify my data.
I need to make everything one of two words in Column A: Size or Capacity. Which word is dependent on the value in Column B (if inches then size...if not, then capacity).
Problem is, there are a ton of variations through a ton of data.
So, I was thinking an IF THEN or something, I just don't know how to build that function.
Any help is appreciated! Sorry if this has already been answered...didn't get far searching for it.
Bookmarks