I have a spreadsheet with this value in A1. This is the actual text in A1:
Active/Inactive <-- Active/Inactive
What I need to do is move the "<-- Active/Inactive" to column B1 and leave "Active/Inactive" in column A1.
I have a list of 50 values and all of the values that need to move to column B are prefaced with this string: "<-- "