Does anyone know how to reverse cell content (text) using the following example:

Reverse cell A1 ("smith, bob") to ("bob smith") and apply results in B1?

Additionally, any hints on counting text letters in cells ("xxxxxx" would equal 6)