Avatar of impala6
Flag for United States of America

asked on 

Need to move part of a text string to another column in Excel

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: "<-- "
Microsoft ExcelSpreadsheets

Avatar of undefined
Last Comment
Professor J

8/22/2022 - Mon