LinkBack URL
About LinkBacks
I used this for column B
Formula:
=MID(A1,3,SEARCH(")",A1)-2)
I got this to work for the entire column C
Formula:=TRIM(SUBSTITUTE(SUBSTITUTE(RIGHT(SUBSTITUTE(A1,".."," "),25),".","",1)," ³",""))
I used this for column B
Formula:=MID(A1,3,SEARCH(")",A1)-2)
I got this to work for the entire column C
Formula:=TRIM(SUBSTITUTE(SUBSTITUTE(RIGHT(SUBSTITUTE(A1,".."," "),25),".","",1)," ³",""))
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks