Mudcat Café message #3627086

The Mudcat Café ^TM
Thread #154550 Message #3627086
Posted By: Bonzo3legs
19-May-14 - 11:03 AM
Thread Name: BS: Excell spreadsheet question
Subject: RE: BS: Excell spreadsheet question

if you put 123 Child in cell A1 you can reverse the order with this formula:

=RIGHT(A1,LEN(A1)-SEARCH(" ",A1))&" "&LEFT(A1,SEARCH(" ",A1)-1)