Quick helpers
Thursday, 30 May 2013
Swapping two strings in Excel cell
Strings must be delimited with space e.g. "John Doe"
=TRIM(MID(A2,FIND(" ",A2)+1,1000))&" "&LEFT(A2,FIND(" ",A2)-1)
No comments:
Post a Comment
Newer Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment