Hi All,
Is there anyway to detect specific text from a sentence in excel. for example I have addresses in col A and I want only the post code to be display in Col B.
See below for an example.
A B 15 Galowgate Edinburgh EH12 5DL EH12 5DL 25 London Road Glasgow G5 3PL G5 3PL
Is it last 2 words always.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
For this scenario yes,
But also good to know how to pick up specific part of text in a sentence for example take 2.2 from 'Ford Transit Custom 290 L1 Diesel Fwd 2.2 TDCi 1'
Originally Posted by kvsrinivasamurthy
As to the examples in post #1 try the following:Formula:
=MID(A1,FIND("@",SUBSTITUTE(A1," ","@",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))-1))+1,255)
*This formula is credited to the linked article.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks