Is there a way to count the numbers of characters between two characters? I don't need to extract,just count. I am trying to count the number of characters between "-", if there is more than one, they are separated by commas .i.e:
1-1-name1 <---- this should result as 1
1-2,3-name2 <---- this should result as 2
1-2,3,4-name3 <---- this should result as 3
Any ideas?
well....
"," counts as character...so you want to exclude ,?
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
thanks, got it working using the len and substitute command
So this will work if you include comma
Formula:
Please Login or Register to view this content.
however if you want to exclude comma
maybe this
Formula:Please Login or Register to view this content.
Last edited by humdingaling; 06-29-2017 at 10:08 PM. Reason: didnt need that extra IF
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks