Studio 2009: How to search and replace including subscript tags
Thread poster: Erik Freitag

Erik Freitag  Identity Verified
Local time: 09:08
Member (2006)
Dutch to German
+ ...
Oct 12, 2011

Dear colleagues,

I'm translating a largish excel document with lots of occurances of a chemical formula in the running text. I was trying to save me the effort of manually adding the necessary subscript tags each time, but this seems impossible, as neither Multiterm, nor Autotext, nor search&replace seems to be able to cope with those tags. What I get is always the whole formula with all regular characters (as in "H2O", whereas I'd like the "2" to be subscript).

Is there any possibility to achieve what I want (preferrably by search&replace, as I've already completed the translation)? Is it an extra obstacle that the document is an excel table?

Many thanks in advance,
kind regards,


István Hirsch  Identity Verified
Local time: 09:08
English to Hungarian
After completing the translation Oct 12, 2011

I suggest doing this with the saved target (backup) file in Word (then copy/paste it back to Excel).

Go to Find/Replace and check Wildcard checkbox.
(to find every letter that is directly followed by a number)
Replace with:
(to put these numbers between ßs /or any other suitable character that the text does not contain/).

(to find numbers between ß)
Replace with:
\2 (Format/Character: subscript)
(to format them as subscript and delete ß).

Before these operations check the text for possible unwanted conversions, for example, in „Audi A8” the number would also be converted to a subscript.

If you mean that a single formula occurs many times (not several formulas) then in the first step, for example,
Find: H2O
Replace with: Hß2ßO
the second step should be the same as above.

[Módosítva: 2011-10-12 10:21 GMT]

[Módosítva: 2011-10-12 10:38 GMT]


To report site rules violations or get help, contact a site moderator:

You can also contact site staff by submitting a support request »

Studio 2009: How to search and replace including subscript tags

Advanced search

SDL Trados Studio 2017 only €435 / $519
Get the cheapest prices for SDL Trados Studio 2017 on

Join this translator’s group buy brought to you by and buy SDL Trados Studio 2017 Freelance for only €435 / $519 / £345 / ¥63000 You will also receive FREE access to Studio 2019 when released.

More info »
Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for users! Save over 13% when purchasing Wordfast Pro through Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

More info »

  • All of
  • Term search
  • Jobs
  • Forums
  • Multiple search