FryGirl
Well-known Member
- Joined
- Nov 11, 2008
- Messages
- 1,364
- Office Version
- 365
- 2016
- Platform
- Windows
Hello All,
In VBA, is there another way to count the cell below to give the count of number of "/"? In this case, it should be 5, as I'm counting text that has been concatenated with the "/" as the separator.
I'm currently using this on the spreadsheet =LEN(C2)-LEN(SUBSTITUTE(C2,"/",""))+1
Nancy Davolio / Barry Milo / Nolan Mike / Mcdowell Cesar / Zimmerman Colby
In VBA, is there another way to count the cell below to give the count of number of "/"? In this case, it should be 5, as I'm counting text that has been concatenated with the "/" as the separator.
I'm currently using this on the spreadsheet =LEN(C2)-LEN(SUBSTITUTE(C2,"/",""))+1
Nancy Davolio / Barry Milo / Nolan Mike / Mcdowell Cesar / Zimmerman Colby