Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top


I am experiencing issues with Google Spreadsheet.

The thing is that me and my colleagues are using one spreadsheet as a table for translations, there is a column for English and then German and French and we have specific piece of text in each row for translation.

The thing is that we need to translate pieces of text with HTML tags like

<span style="color:#AC0000">Translate <strong>this</strong> please</span>

There are actually more HTML tags than that and my colleagues are not really "HTML compatible" so my question is if there is some possibility to hide those html tags for them and make them only visible to me or well any method that would make it easier. Of course there is a possibility to copy those pieces of text without HTML formatting and then just format the final translation again, but it would take an awful lot of time.

I am kindly open to all suggestions and thank you in advance!

share|improve this question

closed as off-topic by random Jul 11 '15 at 0:46

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "This question is not about computer hardware or software, within the scope defined in the help center." – random
If this question can be reworded to fit the rules in the help center, please edit the question.

up vote 1 down vote accepted

Here is how to remove the HTML tags with Google Spreadsheets:

  • =RegexReplace( A1, "<\/\w+>|<\w+.*?>", "" ) where A1 is a cell containing HTML

Google Spreadsheet Demonstration

Note

  • For every HTML tag in A1, A1 must have both the open < and the close >
  • The plaintext (non-HTML) should avoid < and > because it could cause false positives.

Without doing a word-for-word translation, it is unlikely that you can take the translated text and inject the original HTML programmically. This is because some words translate into multiple words and sentence structure can change when translating.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged .