I need to remove the last word of a cell/string. This should be simple but I am braindead at the moment. Thanks for your help.
I have this:
Billy Bob's Law Office 700, Corporate Ste 201 ,
I need this:
Billy Bob's Law Office 700, Corporate Ste 201
So, basically I need to clip the comma off the end. I can't use a subsitute because it will replace all the commas. Thanks again.
Aaron
I have this:
Billy Bob's Law Office 700, Corporate Ste 201 ,
I need this:
Billy Bob's Law Office 700, Corporate Ste 201
So, basically I need to clip the comma off the end. I can't use a subsitute because it will replace all the commas. Thanks again.
Aaron