• 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 to remove formatting symbols from Word doc (text) pasted into excel

budimu

New Member
I have information I download into an excel file, but it contains formatting symbols from word. In order to see the formatting symbols you have to copy the text into word and click on the show/hide formatting button to see them and delete them. Is there a formula for excel or a short key that will delete them instead of having to paste into word, take out formatting symbols,and then paste back into Excel?


after i used the Clean and clear format functions, i still have formating symbols that i need to get rid off. I need to get rid off the below formating symbols:


-paragraph mark (not paragraph character!!!)


-tab character


-column break


-manual page break


-Section Break


-Section character


Sorry i know it is a lot, but any help would be greatly appreciated!!!! thank you so much !!!!!
 
Hi Budimu,


=TRIM(CLEAN(SUBSTITUTE(LEFT(TRIM(A7),LEN(TRIM(A7))-OR(RIGHT(TRIM(A7))={"?","!","."})),CHAR(160)," ")))


Ref : http://www.rondebruin.nl/clean.htm


Regards,

Deb
 
Budimu


You may also want to look at using the Selection Pane

The same issue is discussed here in the Uses section: http://chandoo.org/wp/2010/12/02/the-selection-pane/
 
<p> One of the best ways to learn more about this brand name designer is to visit an online Karen Millen outlet. Here, you can read more about the various Karen Millen dresses that are on sale as well as learn more about other items such as shoes. This is also a great way to get more information on current pricing as well as read about the quality craftsmanship this designer consistently delivers in its many offerings.</p>


<p> </p>


<p>1. <span style="color: #ff6600">Karen Millen Dress</span>

When we raising the question that what dresses are suitable for the gentlewomen, you must think of the Karen Millen dresses, yes, Karen Millen is always the symbol of gentle lady. Although there are many bright colors of Karen Millen dress, they can be matched with other clothes or accessories easily.Actually, wearing the gray check skirt will make you looks older than your real age. So there is a tips for the collocation from the Karen Millen that use the sapphire blue or the peacock green to match with gray check skirt will make you looks like younger than before.2. Bright Color

The fashion designers said that summer is a season which should be covered by all kinds of bright color, otherwise, summer cannot be called summer. So we can know that why there are so many girls and boys like to wear the green or red clothes in the summer.That means bright color is the permanent color of summer, but how to deal with the very bright color, such as the sapphire green and blue color. Well, where there is problem, there is solution, if you really like the clothes with a too bright color, the best way to make you looks like a little low-profile is to wear a black trousers or a skirt. That will reduce the possibility of making mistakes.3. Chiffon Clothing

Chiffon Dress is the best choice for every girl in the summer since it is thin enough to show out our girl's beautiful figures. So, to learn how to correctly wear the chiffon clothes is a good idea.Actually, most of the chiffon clothes are pure white or the nude color, actually the nude color is closed to our skin color, so it is not so easy to wear it and you should choose a suitable color for your skin. When wearing the chiffon dress, the key is to wear a bright color belt. </p>


<p> sale on www.keren-millen-km.co.uk/</p>


<p>Several years ago, the fashion editors began to beat the idea of "Waist Skirt Match with Wide Belt" into our head. Surely, it is vintage and good-looking. But we seem to be limited by these thoughts.Actually, if you are the fans of fashion show, especially, if you are a fan of <span style="color: #ff6600">Karen Millen Dresses</span>
you will see that the waist skirt is began to match with the thin belt in the latest fashion shows. Yep, this collocation is very popular recently.Hurry up; just renew your idea of the fashion trend. Following are three suggestions for this hot summer season and the cool coming autumn. Let's see what's hot in our fashion designer's mind?</p>


<p> </p>


<p> While there are many reasons women love this brand, one of the more important is that Karen Millen offers a full line of quality apparel. The brand's most famous line is, of course, their Karen Millen dresses, but women can also find other products as well. For instance, with the weather being cool, owning a Karen Millen coat is not only a wise decision, but can also be achieved now while saving money. Now, stylish women can fight off the chill while looking great and keeping more money in their purse.</p>

<p> Visitors to the g><span style="color: #ff6600">Karen Millen outlet</span> may want to bring a cup of tea or coffee with them as they visit. The site is full of many attractive items including dresses and coats to meet any need or budget. As mentioned above, the outlet offers apparel for both day and evening wear, and many items that are appropriate for business wear. But, the only way to know what is being offered is to visit the site and browse their pages which are easy to navigate, uncluttered and user-friendly. Visitors can also learn more about shipping and guarantees offered by this vendor.</p>

<p>For quite some time, Karen Millen Dresses have been a staple for women who care about their appearance. And, there are some very good reasons for this appeal. When it comes to style and quality, <span style="color: #ff6600">Karen Millen sale</span> apparel has long been a favorite of many women. Now, with a Karen Millen sale going on, women of all ages and incomes can enjoy this famous label designer.</p>


<p> Many of those who are familiar with this brand name can attest to its quality. Karen Millen products are crafted with care by experienced personnel who know the importance of details. The line is crafted from high-quality materials that can stand the test of time as well as wear well during a busy work day or hot night on the town. No one wants to spend money on low-quality garments that lose their appeal within a short period of time. <span style="color: #ff6600">outlet Karen Millen</span>
, consumers know they are getting some of the best.</p>


<div class="img"><img title=" Karen Millen One Shoulder Dress Black " alt="Karen Millen One Shoulder Dress Black" src="http://www.karen-millen-km.co.uk/bmz_cache/3/3300e58f5456446dd6c1c005260b76e8.image.220x342.jpg" width="220" height="342" /></div>

<div class="prod-info">Karen Millen One Shoulder Dress Black

<div class="text">Description:* Signature matt and shine stretch black tailore...</div>

</div>


<div class="img"><img title=" Karen Millen Sculptural Frill Short Dress Neutral " alt="Karen Millen Sculptural Frill Short Dress Neutral" src="http://www.karen-millen-km.co.uk/bmz_cache/5/59f751f4c4a599bf6434efdf5e039af6.image.220x342.jpg" width="220" height="342" /></div>

<div class="prod-info">Karen Millen Sculptural Frill Short Dress Neutral

<div class="text">Description:* Stretch satin one shoulder pencil dress with i...</div>

For those who want to accessorize their new Karen Millen dresses, the designer offers a full line of wonderful shoes. These shoes are not only comfortable, but they are also the height of stylishness and can complement virtual any outfit the woman may be wearing. The line offers styles appropriate for day-wear as well as evening wear. And, as mentioned above, customers can take advantage of the Karen Millen sale now going on through this online Karen Millen outlet.</div>


Related articles:

>[*]http://obxcondo.com/viewtopic.php?f=2&t=1
 
thank you guys!!!!!! i can now sleep in peace :):) !!! i spent the whole freaking day trying to figure out what to do!!!! :)
 
Back
Top