Another quick post:
Have you ever had the wonderful pleasure of needing to pull all characters to the right of the 2nd or 3rd space within the string? I know I have..
Solution:
*Disclaimer*: I have no idea where I found this beauty, but again, I FOUND it because someone else was willing to share - and sharing is the whole point of this blog... I'm posting this just as much for myself as for anyone else. :)
Assuming your string is in cell C2:
=FIND(CHAR(1),SUBSTITUTE(C2," ",CHAR(1),LEN(C2)-LEN(SUBSTITUTE(C2," ",""))-n))
For n:
("n" determines the number of spaces)
0=1
1=2 etc...
Using Microsoft Excel 2013, Everyday Excel 1-2-3 is designed to share some "everyday" experiences, tips or tricks for Microsoft Excel users. Target reader experience will range from Beginner to Expert and posts will often reach out to each group but not every group always. Comments are welcome and highly encouraged. Suggestions for topics are welcome, but solutions to specific problems will not necessarily be provided. Part of learning is struggling, and we're all struggling together.
No comments:
Post a Comment