I need a macro that will insert this formula: =Trim(IF(B3="","",MID(B3&", "&B3,FIND(" ",B3)+1,LEN(B3)+1))) into column C starting on row three through the end of the spreadsheet information.
Thank you
ADDENDUM:
I typed this incorrectly when I first posted. I need it to fill down into only column C not the end of the spreadsheet. The below macro is really close but I don't have enough knowledge to change it to do what I need. Please advise. Thank you
Bookmarks