LinkBack URL
About LinkBacks
Process would be:
Count the number of commas.
If one Coma short, then replace the appropriate coma with two commas.
Formula for C2
Formula:
=IF(LEN(B2)-LEN(SUBSTITUTE(B2,",",""))=4,B2,SUBSTITUTE(B2,",",",,",1))
Process would be:
Count the number of commas.
If one Coma short, then replace the appropriate coma with two commas.
Formula for C2
Formula:=IF(LEN(B2)-LEN(SUBSTITUTE(B2,",",""))=4,B2,SUBSTITUTE(B2,",",",,",1))
Last edited by mehmetcik; 10-09-2019 at 01:26 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks