Find and Replace - A bit more complicated

[Helen]

Hello,

I tried finding a solution by myself, but no-can-do. How can I tell Word to:

a) Find the dollar sign ($) and;
b) Place it at the end of the amount instead of the beginning, i.e., change
$10,000 for 10 000 $.

It also has to be preceded by a hard space.

Thank you!

Hélène

 

[Helmut Weber]

Hi Helen,

how regular are the amounts?
lowest ? 0.5 ?
highest ?
e.g. 10,000,333,444,555
Decimal fractions?

It also has to be preceded by a hard space.

A hard space before dollar sign, right?

--
Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"

 

[Helen]

Hi Helmut,

The amounts could be different but mostly as follows:

$10,000.88 -- $1,234.88 -- $123,898,999.00

There would be decimal fractions and they too will have to be changed. For
example, the decimal separator will now become a comma instead of a period.

It is a case of converting English amounts into French amounts.

Thanks.

Hélène

 

[Helmut Weber]

Hi Helen,

you need to know quite a bit about macros.

If so then
may I suggest to ask again in
microsoft.public.word.vba.general

There are more people enjoying questions like that.

I'm thinking about a programmatic solution,
but in case you've never used a macro,
it would be very hard.

--
Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"

 

[Helen]

Helmut,

I appreciate you taking the time to make this suggestion and I will most
certainly follow it.

Thank you! And greetings from Montreal, Canada!

 

[Graham Mayor]

Use a wildcard replace of
($)([0-9,.]{4,})
with
\2 \1
If there are no cents in your numbers change the 4 in the search string to 2
See http://www.gmayor.com/replace_using_wildcards.htm
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>