| Find position of first space | =FIND(" ",A1) |
| Find position of second space | =FIND(" ",A1,FIND(" ",A1)+1) |
| Find position of third space | =FIND(" ",A1,FIND(" ",A1,FIND(" ",A1)+1)+1) |
| Find position of forth space | =FIND(" ",A1,FIND(" ",A1,FIND(" ",A1, FIND(" ",A1)+1)+ 1)+1) |
Monday, November 20, 2017
EXCEL - Find position of the Nth space in a string
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment