Is there a way in Excel, using formulas or VBA, to look for certain text in a string in Column A and, if found, to copy/paste it into other columns?
For example:
Cell A1 = Can share; Word List; Computer; 10 min/hr
The formula should put “Can share” in C1 , “Computer “in D1 , “10 min/hr” in B1 and so on.
Another example with multiple texts to go one column as in A10 =Technology Software; Printing Needs; Bring items; Cannot share; Nursing extra time (20 mins 1st yr, 10 mins 2nd yr, 5 mins 3rd yr, 0 mins NURS703); Flexibility to move; Morning; 48hrs
The formula this time should put “Technology Software” in D1 , “Printing Needs , Bring items, Flexibility to move” in H1 ,” Cannot share” in C1, : Nursing extra time (20 mins 1st yr, 10 mins 2nd yr, 5 mins 3rd yr, 0 mins NURS703)” in B1 , and “Morning , 48hrs” in F1.
So when there are multiple strings to be copied ina cell, they should be separated by “,”
A1 list in first sheet in the attached spreadsheet has different texts, and they should be copied into the respective columns in the first sheet as per the mapping table in the second sheet in the attached spreadsheet.
Many thanks in advance for any help
