Hi, I need help with some copy and pasting help within excel.
In column M, all of my cells begin with "Door Surf Color:" Followed by a code or a word which is then followed by a space and then more text.
I am looking for a way for a macro or something like it to read the cell, copy the word or code that follows "Door Surf Color:" and then paste that word or code into the column AT in that same row.
Any help would be greatly appreciated. Thanks!
In column M, all of my cells begin with "Door Surf Color:" Followed by a code or a word which is then followed by a space and then more text.
I am looking for a way for a macro or something like it to read the cell, copy the word or code that follows "Door Surf Color:" and then paste that word or code into the column AT in that same row.
Any help would be greatly appreciated. Thanks!