Mobile menu

€€€€€ - Getting these little guys to the left in MS-Word
Thread poster: Edward Potter

Edward Potter  Identity Verified
Local time: 07:36
Member (2003)
Spanish to English
+ ...
Dec 28, 2007

Does anyone have a good workaround for getting those pesky little euro signs from the right side of my numbers to the left side?

Example:

I want this list

55.33 €
23.99 €
46.59 €
78.21 €

to look like this list

€55.33
€23.99
€46.59
€78.21

with only 3 clicks.

How can I do this?


Direct link Reply with quote
 
Margreet Logmans  Identity Verified
Netherlands
Local time: 07:36
English to Dutch
+ ...
Type them? Dec 28, 2007

How did you make that first list in the first place?

Direct link Reply with quote
 

Claudia Alvis  Identity Verified
Peru
Local time: 01:36
Partial member
Spanish
+ ...
Find/Replace with Wildcards Dec 28, 2007

You could do a Find/Replace with wildcards. Use:

Find what:
([0-9][0-9]).([0-9][0-9]) €

Replace with:
€\1.\2

Make sure 'Use Wildcards' is checked. That is if all your numbers have the same format, if not, you can modify it a bit. That should work.

[0-9] Represents any digit
\1 represents what's in the first bracket, which is ([0-9][0-9])
\2 represents what's in the second one.

Good luck


Direct link Reply with quote
 

Edward Potter  Identity Verified
Local time: 07:36
Member (2003)
Spanish to English
+ ...
TOPIC STARTER
Type them Dec 28, 2007

Hi Margreet.

Thank you for your reply. But, do you see where I am coming from here? What do I do when I have 2000 numbers on my list? Type them?


Direct link Reply with quote
 

Renée van Bijsterveld  Identity Verified
Netherlands
Local time: 07:36
Member (2007)
English to Dutch
+ ...
Create a table Dec 28, 2007

If it's a long list I would convert the list to a table (two columns), with the numbers in one column and the euro sign in the next. Then you can cut the euro column and paste it on the left side.

Or you could import/copy the amounts into an Excel table, delete the euro sign, and reformat the amounts to show the currency sign.
Good luck,
Renée


Direct link Reply with quote
 

Edward Potter  Identity Verified
Local time: 07:36
Member (2003)
Spanish to English
+ ...
TOPIC STARTER
Wildcards Dec 28, 2007

Aha! That is what I was looking for! Thank you!

Direct link Reply with quote
 
Margreet Logmans  Identity Verified
Netherlands
Local time: 07:36
English to Dutch
+ ...
No, but.... Dec 28, 2007

This ís Word, we're talking about, right?
How did you make your original list? I assume you're looking for an automated setting, but I don't understand which setting you used in your first list.

In Excel, this would be easy. RenéevB's suggestion is workable.

Did you copy and paste the numbers froms somewhere else? Or did you get it like this from a client?

I didn't mean to be unfriendly, I meant to say you needed to give a little more information about this. Sorry if it didn't come across like that.

Margreet

[Edited at 2007-12-28 15:59]


Direct link Reply with quote
 

Lesley Clarke  Identity Verified
Mexico
Local time: 00:36
Spanish to English
Thanks Dec 28, 2007

Thanks to Edward for asking the question and Claudia for answering it, you've made my day.

I see this can also be adapted for that horrible decimal comma. Wonderful!


Direct link Reply with quote
 

Sylvain Leray  Identity Verified
Local time: 07:36
German to French
CAT-tool ? Dec 28, 2007

Edward, do you use a CAT-tool ? If yes, "translate" the first row and apply your translation to the other rows automatically, and it should do the trick.

Sylvain


Direct link Reply with quote
 

Boris Sigalov
Local time: 08:36
English to Russian
Wildcards Dec 28, 2007

Claudia Alvis wrote:

You could do a Find/Replace with wildcards.


Very interesting and really useful technique, Claudia! Could you recommend a place in the internet where I can read how to create wildcards for various Find/Replace purposes?


Direct link Reply with quote
 

Claudia Alvis  Identity Verified
Peru
Local time: 01:36
Partial member
Spanish
+ ...
Website Dec 28, 2007

I haven't read it thoroughly though.

http://word.mvps.org/FAQs/General/UsingWildcards.htm


Direct link Reply with quote
 


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


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

€€€€€ - Getting these little guys to the left in MS-Word

Advanced search






CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use SDL Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

More info »
Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »



All of ProZ.com
  • All of ProZ.com
  • Term search
  • Jobs