Text separation by formula

**L-Drr** · 09-22-2013, 08:18 AM

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

**oeldere** · 09-22-2013, 08:27 AM

@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.

**nur2544** · 09-22-2013, 10:20 AM

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)

(assuming that all phone numbers are 12 characters long)
(assuming all email numbers are 9 characters long)

the characters of Mobile number & email number might be varies that is also problem. however please don't wast your valuable time regarding this.
i will do my job manually what i am currently doing. thanks for your supports..