• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula please

Hi,


With "http://www.wto.org." including quotes and fullstop, try this


=HYPERLINK(MID(A1,2,LEN(A1)-3))
 
you mean you want to remove the double inverted quotes and the dot after org


try this..


=MID(A1,2,LEN(A1)-3)
 
@Manjunath,


Yes I did, only I'd put the LEN in B1 and referred to that first :-( , now corrected thanks for pointing it out :)
 
HI oldchippy!


Thanks! I tried that but not getting proper output.I dont want underline beneath the site name. when I place every time i use the angular tags to high-late the site. Kindly could you upload the proper formula once


Thanks

Ashok
 
Ashokraju


If your are using Excel 2010


Select the output Cell >> Home Tab >> Cell Styles >> select Normal


This will make the cell content/ hyperlink look like any other normal cell but hyperlink will remain intact.


EDIT:


alternatively you can also do this:


Select the Cell>> Home Tab>>clear>> Clear formats
 
<div class="ProductImage">, glove box, the hundreds more.Birmingham more than 700 retail stores in the United Kingdom's second largest city, from the large retail stores and brand colorful side street, you will want to spend a few days here.EdinburghThe beautiful city, Edinburgh is the capital of Scotland and providing a good shopping experience. Whether you are looking for a special occasion clothing, trendy casual wear, or perhaps tartan berries and kilt, you will get all of these, when you hit the Edinburgh shopping streets.If you are looking for a luxury store Louis Gateway Gordon and Harvey Nichols are sure to meet. Princes Street is Edinburgh's main shopping boulevard, mentioned in many high street shops in London and Birmingham. You browse the wonderful shops and the streets of Edinburgh, you will also have plenty of opportunities to buy some souvenirs.</div>


<p><span style="color: #ff6600">Karen Millen dress</span>[/b][/i] is the hottest brand in the summer program, and from this designer brand is packed with stars, celebrities, singers, fashion magazine editor, who is who of the fashion and glamor world gills. If you have not heard the buzz, to solve this fashion label, or read fashion magazines around the world, you have been retrieved from under a rock, because it is the lips almost any one who knows what is the name of the world around Fashion Week during the spring and summer of 2011, all about fashion this season.At, buzz has been around the hot new designer label, is the most elegant and luxurious clothes seen on the ramp Iceland and the women in the long time . The. In fact, the world's fashion capital catwalks, the brand owned by the Icelandic company, in fact, many years ago, people from the United Kingdom. The company began almost three decades, but many people believe that the company is a hot new company.</p>

<p>LondonLondon is classified as one of the world's top shopping, the exciting and famous Harrods and Harvey Nichols, many of its streets, colorful alleys and bustling markets, London has it all when it comes to the latest fashion trends and must haves.London list one of the world's major fashion capital, is the most suitable for its fashion, style, electric hybrid and trends. Versace, Prada and like your stuff, then go to the place of the Bond Street. Luxury shops, Regent Street is a wonderful gem of free storage, such as Laura Ashley, the connection to France, Benetton colors and many more.Convent garden answer is London's fashionable shopping district, you will find an exciting experience in Covent Garden shopping, a lot of things you buy here, you can not get elsewhere! The garden of the monastery is a lot of designer shops, boutiques and, of course, quaint little restaurants and coffee love, where you can discard plastic bags, and from all the shopping time! Of course, no shopping trip is no access to London's Oxford Street. Oxford Street is truly a shopper's paradise, providing the latest fashion trends all tastes, shapes and sizes! Oxford Street may have one of the highest on a street shops than anywhere else in the world of content. Selfridge Miss Riverisland top of the shop to GAP list endless.Birmingham revitalization, wardrobe you? Shopping to meet your desire for it?</p>

<div class="sideBoxContentItem"> and Kevin of Stanford University, early as ninety-eight on the white shirt for women has been borrowed princely sum of one hundred pounds, so the legend from its name. Obviously, the amount of funds they use to buy one thousand meters of white cotton, and then made into shirts and sales profits. Planning, and in about a year, they opened their first retail store in Kent, England. This is to do so, in nine hundred eighty-three and shops within a year, they expanded again to the local, such as Brighton, Guildford and the city of London itself.Today company ultimately depends on which way the enormous and tiny you look at it. Small team of creative director the Gemma Metherhingam supervision of only 12 designers favorite of the label's award-winning after year.The of the Karen Millen brand fashion and bake so much a collection, although there are many, many shops and justice in the United Kingdom and Ireland's own brand, has more than Eighty-four position, alone more than 16 stores in the Twenty-three countries of the store. The best place to look at the latest collection, although it is online, where you can browse and easy to buy the entire collection.</div>

<div class="ProductImage"><img title=" Karen Millen UK 20s pleat dress lilac " alt="Karen Millen UK 20s pleat dress lilac" width="125" height="200" style="position: relative" src="http://www.karen-millen-dresses-outlet.co.uk/bmz_cache/8/83d3d032231529fc58841adcca068ae4.image.125x200.jpg" /></div>

<div class="ProductDetails">Karen Millen UK 20s pleat dress lilac[/b]</div>

Related articles:

 
Back
Top