Ok Yes I did try and google... for like 10 seconds but found this easier so all of you people that will write search in google, get rooted

Ok so I have an excel document that has a cell with a full name lets say
the name is Perth WRX

How do I run a formula to grab the 2nd word being WRX of course and move it one cell to the right?

So then I can have two cells one with First Name and the 2nd with Last Name

Thanks!