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
Please supply a workbook with the above in. It's unclear whether the starting data has qute marks in. A workbook will answer a number of other questions which otherwise we'd have to guess at (probably wrongly).
(I foresee a difficulty with the last entry TRSDS and identifying whether it's a person's name or an ID)
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Reply With Quote
