LinkBack URL
About LinkBacks
In B1: =MID(A1;2;12) (assuming that all phone numbers are 12 characters long)
In C1: =MID(A1;FIND("*·*";A1)+3;FIND("*· ";A1;FIND("*·*";A1))-FIND("*·*";A1)-3)
Maybe my semicolons should be commas for you
In B1: =MID(A1;2;12) (assuming that all phone numbers are 12 characters long)
In C1: =MID(A1;FIND("*·*";A1)+3;FIND("*· ";A1;FIND("*·*";A1))-FIND("*·*";A1)-3)
Maybe my semicolons should be commas for you
When I say semicolon, u say comma!
Wow don't know what happened, the *'s in my formulas were spaces. But I had some trouble with your data (had to copy some characters from them because they weren't what they appeared to be), so maybe try to recreate my formulas instead of copying them
@L-Drr
If you want the file, see this link.
http://www.excelforum.com/excel-prog...56#post3415056
@nur2544
In future stick with the original question, according the forumrules (see below).
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hi L-Drr , thanks for replay, below formula showing #VALUE!, rest are working fine.
C1: =MID(A1,FIND("*·*",A1)+3,FIND("*· ",A1,FIND("*·*",A1))-FIND("*·*",A1)-3) D1: =LEFT(A2,FIND("*at",A2)-1)the characters of Mobile number & email number might be varies that is also problem. however please don't wast your valuable time regarding this.(assuming that all phone numbers are 12 characters long)
(assuming all email numbers are 9 characters long)
i will do my job manually what i am currently doing. thanks for your supports..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks