Sunday, May 19, 2013

Excel Formulas: Separating String Values between spaces

place these formulas side by side in two columns..

=LEFT($A1,FIND(" ",$A1)-1)
=RIGHT($A1,FIND(" ",$A1)-1)
Posted by at
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)