LinkBack URL
About LinkBacks
OK try this (Im sure someone will offer a more elegant suggestion though)....
=LEFT(A1,FIND("xx",SUBSTITUTE(A1,".","xx",LEN(A1)-LEN(SUBSTITUTE(A1,".",""))),1))&MID(A1,FIND("xx",SUBSTITUTE(A1,".","xx",LEN(A1)-LEN(SUBSTITUTE(A1,".",""))),1)+1,99)+1
OK try this (Im sure someone will offer a more elegant suggestion though)....
=LEFT(A1,FIND("xx",SUBSTITUTE(A1,".","xx",LEN(A1)-LEN(SUBSTITUTE(A1,".",""))),1))&MID(A1,FIND("xx",SUBSTITUTE(A1,".","xx",LEN(A1)-LEN(SUBSTITUTE(A1,".",""))),1)+1,99)+1
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Wow. Thank you very much! This formula works like a charm. For anyone who sees this in the future just replace the A1 in Ford's formula with the cell name that has the "value" you want to start with.
-Alex H.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks