In Column B I have names with Id's underneath. I need to add the names in Column A, via macro.
COL B "Smith" TH123 12334 REBBB 56322 43433 "Jeffs" 65433 223344 212311 123 "Randal" W2123 TRSDSCol A Col B Smith Smith TH123 Smith 12334 Smith REBB Smith 56322 Smith 43433 Jeffs Jeffs 65433 Jeffs 223344 Jeffs 212311 Jeffs 123 Randal Randal W2123 Randal TRSDS