Try using Data--Text-to-Columns... then go to Delimited and select space.

Other then that I know functions to switch last and first names but not with
extra data involved.

"Big UT Fan" wrote:

I have a column which is in the format of "Lastname, Firstname
textidonotcareabout".
I'd like to change the text to Firstname Lastname via a function. Is this
possible? If not then I'm trying to learn some basic VBA programming so a
macro could be an option. Thanks in advance!