<div>
Awesome @SerenaHsi<br />
<br />
Thanks!<br />
<br />
Next question, is there a way to do this with Google Docs Spreadsheets (on Google Drive)?
</div>


<div>
Next questions, <br />
How exactly do I set this up in Excel 2010? Do I go into Visual Basic Editor? Please could you send a couple of screenshots?
</div>


<div>
Regarding Google Docs I think I figured this out myself, I'm going to use an add-in called &quot;Power Tools&quot;
</div>


<div>
For Google Sheets, goto:<br />
<a href="https://gist.github.com/akora/51b2933a2554776d7144" rel="ugc">Replace accent marks as a formula</a><br />
<br />
For tutorial on how to mod and use Google scripts in Google Docs:<br />
<a href="https://developers.google.com/apps-script/quickstart/macros" rel="ugc">https://developers.google.<wbr />com/apps-s<wbr />cript/quic<wbr />kstart/mac<wbr />ros</a>
</div>


<div>
<a href="https://support.office.com/en-us/article/Edit-a-macro-ed9e8c3d-58fd-47a1-83eb-bdee680376bb#bm1" rel="ugc">Microsoft Office Support KB</a> on how to access the Developer toolbar.
</div>


<div>
<div class="content wysiwyg-content">
I have a list of customers address. Some folks from Germany, Sweden, etc., have funny squiggles above or below many of the letters. I would like to make a simple formula to take the letter and then replace it with a regular ASCII letter that won't cause me any errors in my shipping application.<br />
<br />
i.e. say column A has the original address with all the tildes, accents and squiggles. Column B will return the same complete address, but with the necessary letters replaced with the standard ASCII equivalent. Column B will be the &quot;clean&quot; list.<br />
<br />
Can you please help? <br />
<br />
:D
</div>
</div>


I have a list of customers address. Some folks from Germany, Sweden, etc., have funny squiggles above or below many of the letters. I would like to make a simple formula to take the letter and then replace it with a regular ASCII letter that won't cause me any errors in my shipping application.

i.e. say column A has the original address with all the tildes, accents and squiggles. Column B will return the same complete address, but with the necessary letters replaced with the standard ASCII equivalent. Column B will be the "clean" list.

Can you please help? 

:D

how to use an excel formula to remove accent marks from characters, like ñ é ü í ó

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

A font is a particular size, weight and style of a typeface. Each font is a matched set of type, one piece (called a "sort") for each glyph, and a typeface consists of a range of fonts that share an overall design. With the advent of digital typography, font is frequently synonymous with typeface, although the two terms do not necessarily mean the same thing. In particular, the use of "vector" or "outline" fonts means that different sizes of a typeface can be dynamically generated from one design. Each style may still be in a separate "font file" -- for instance, the typeface "Futura" may include the fonts "Futura roman", "Futura italic", "Futura bold" and "Futura extended" —- but the term "font" might be applied either to one of these alone or to the whole typeface.