Thank you in advance for your time and effort.
I figured this would be a common issue, and I would find the answer to this quickly. Nope. So, I have 2 cells, Cell A1 and Cell B1. In Cell A1 I have text that says "Cleveland Tower" (without " "). In Cell B2 I have text that says "Cleveland Tower Painted Red On Tuesday" (without " "). I would like to extract "Painted Red On Tuesday" into Cell C1. So essentially I want to minus A1 from B1 to = C1. I have 3700 rows and there is no set amount of characters I can count in, or commas or periods I can use to split the text in the cell. I just want to remove the text in A1 from B1.
Additional: I should add, that the text in the cells in Column A is always the first text in the cell in Column B. So if there is a way to count the characters in A1 then that is exactly how many I need to remove from B1. Example:
Cleveland Tower - Cleveland Tower Painted Red On Tuesday - Painted Red On Tuesday
Detroit Bridge - Detroit Bridge Painted Black On Monday - Painted Black On Monday
Flint Center - Flint Center Painted Green On Saturday - Painted Green On Saturday
Thanks
Bookmarks