@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
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks