A column in the spreadsheet has the names like this:

Smith, Bob R

I need to parse them out and put them in 3 seperate columns like so:

Smith Bob R.

Does anyone have a macro or formula to do this?

TIA