On Wed, 9 Apr 2008 10:38:01 -0700, 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!

Perhaps:

=LEFT(TRIM(MID(A1,FIND(",",A1)+1,255)),FIND(" ",A1))
& TRIM(LEFT(A1,FIND(",",A1)-1))

--ron