Hi
I have a text in A2. would like to extract the text after 11 characters "AS DESIGN"
see the text..
ORIGINAL SUPPLIER: AP EQUIPMENT IND.LTDA. AS DESIGN: 123,251,168 Rev.0 APPLICATION: USED SPARE NO CARRIER BELT 42 ", TC 01 and TC 02 LD FOOD PLANT OF CONCENTRATION AND SILOS.
The result: 123,251,168
Last edited by marreco; 04-11-2012 at 07:11 AM.
"No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.
If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
marreco,
With that example, this should work:
=--MID(A2,SEARCH("as design: ",A2)+11,11)
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thank you!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks