LinkBack URL
About LinkBacks
-James_ 
You might want to check for the case where the cell has no spaces:
=IF(ISERR(LEFT(A4,FIND(" ",A4))),A4,LEFT(A4,FIND(" ",A4))&TRIM(RIGHT(SUBSTITUTE(A4," ",REPT(" ",50)),50)))
All credit to Dom for the tricky part.
Regards
You might want to check for the case where the cell has no spaces:
=IF(ISERR(LEFT(A4,FIND(" ",A4))),A4,LEFT(A4,FIND(" ",A4))&TRIM(RIGHT(SUBSTITUTE(A4," ",REPT(" ",50)),50)))
All credit to Dom for the tricky part.
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks