Hi Stephen, I did and they work, I was hoping to have this as code though rather than a function on the spreadsheet side of things.works great though and thank you.=IF(ISNUMBER(FIND("(",C2)),MID(C2,FIND("(",C2)+1,FIND(")",C2)-FIND("(",C2)-1),"")
Hi Stephen, I did and they work, I was hoping to have this as code though rather than a function on the spreadsheet side of things.works great though and thank you.=IF(ISNUMBER(FIND("(",C2)),MID(C2,FIND("(",C2)+1,FIND(")",C2)-FIND("(",C2)-1),"")
If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.
---Keep on Coding in the Free World---
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks