I'm fairly new to Crystal Reports and am in need of some help.  I have designed a payroll direct deposit stub for our accounting system.  Everything works great.  However, in my accounting system the employee's name is in this format:  Last; First I.  I need to reverse the order to First I. Last without the semicolon.  When creating a formula, how do I grab the entire last name and lose the semicolon?  (I.e. I can't use the typical Left() function because I don't know how long the last name is.)

Thanks for your help.

Thanks for the help.  That works great.

I will look at your book.  I definitely need a reference guide.

BTW I'm using Crystal with Timberline Software.  It's really great.