title: delete text left of space using excel vba
body: <p>I am writing a macro that will scrub down an excel list. I need to take a list of names and remove the first name, so "John Smith" becomes "Smith". I know how to delete text after a space but before a space seems more tricky.</p>