I am writing a macro and need help manipulating the characters in an address field. Here is a sample line of data;
MISS CARMEN ANDREA BAKS OR
All of this information is contained in one cell. I want the macro to do 2 things.
1) I want it to delete the last 3 characters in the cell if they are _OR
2) I want to separate the first and last names into different cells. In this case the first name would be Carmen Andrea and the surname would be Baks.
I Have been working on this for some time and would really appreciate some advice.
thanks
Mark.
MISS CARMEN ANDREA BAKS OR
All of this information is contained in one cell. I want the macro to do 2 things.
1) I want it to delete the last 3 characters in the cell if they are _OR
2) I want to separate the first and last names into different cells. In this case the first name would be Carmen Andrea and the surname would be Baks.
I Have been working on this for some time and would really appreciate some advice.
thanks
Mark.