Change the way list of names is displayed

Hello.

I need to convert a column of cells with names that look like this: SMITH John
to this: J SMITH

Previously I've been using Text to Columns, then =CONCATENATE(LEFT(B1,1)," ",A1)

I'd like to do this without using text to columns though, is this possible?