Hi,
Is there way to get an if statement that will help me extract a certain data from a particular cell. I need an if statement that will extract the items below names only.
As you can see the only consistency in each Original Name is the "period". So I need a if statement that identifies that "Period" and then return me on the name of the item. PLEASE SEE ATTACHMENT
Bookmarks