search-replace

[Narendra Boga]

Dear All,

I have data like this.

Additional paid-in capital 1 722 286 1 630 394
Accumulated other comprehensive income (loss) (890 446) 239 041
Retained earnings 40 026 498 40 611 396
-----------
Can you please tell me how I replace the spaces in amounts with comma
without replace effecting in descriptions. Only comma should come in amounts
only not in descriptions. I data should like this:

Additional paid-in capital 1,722,286 1,630,394
Accumulated other comprehensive income (loss) (890,446) 239,041
Retained earnings 40,026,498 40,611,396

Thank You
Narendra

 

[Jay Freedman]

Dear All,

I have data like this.

Additional paid-in capital 1 722 286 1 630 394
Accumulated other comprehensive income (loss) (890 446) 239 041
Retained earnings 40 026 498 40 611 396
-----------
Can you please tell me how I replace the spaces in amounts with comma
without replace effecting in descriptions. Only comma should come in amounts
only not in descriptions. I data should like this:

Additional paid-in capital 1,722,286 1,630,394
Accumulated other comprehensive income (loss) (890,446) 239,041
Retained earnings 40,026,498 40,611,396

Thank You
Narendra

Click the More button in the Replace dialog and check the box for "Use
wildcards".

Put this expression in the Find What box (there is one space between the two
groups):

([0-9]) ([0-9])

Put this expression in the Replace With box:

\1,\2

Click the Replace All button.

 

[Narendra Boga]

Dear Jay Freedman,

Thank you for your instant reply. It reduced my time.

Dear All,

I have data like this.

Additional paid-in capital 1 722 286 1 630 394
Accumulated other comprehensive income (loss) (890 446) 239 041
Retained earnings 40 026 498 40 611 396
-----------
Can you please tell me how I replace the spaces in amounts with comma
without replace effecting in descriptions. Only comma should come in amounts
only not in descriptions. I data should like this:

Additional paid-in capital 1,722,286 1,630,394
Accumulated other comprehensive income (loss) (890,446) 239,041
Retained earnings 40,026,498 40,611,396

Thank You
Narendra

Click the More button in the Replace dialog and check the box for "Use
wildcards".

Put this expression in the Find What box (there is one space between the two
groups):

([0-9]) ([0-9])

Put this expression in the Replace With box:

\1,\2

Click the Replace All button.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit.

 

[Von Stussi]

This post is very useful, however when I type the serie with a space:
([0-9]) ([9-0])
I get this message
"The Find What text contains a range that is not valid"

Could you precise,

Thanks

Dear All,

I have data like this.

Additional paid-in capital 1 722 286 1 630 394
Accumulated other comprehensive income (loss) (890 446) 239 041
Retained earnings 40 026 498 40 611 396
-----------
Can you please tell me how I replace the spaces in amounts with comma
without replace effecting in descriptions. Only comma should come in amounts
only not in descriptions. I data should like this:

Additional paid-in capital 1,722,286 1,630,394
Accumulated other comprehensive income (loss) (890,446) 239,041
Retained earnings 40,026,498 40,611,396

Thank You
Narendra

Click the More button in the Replace dialog and check the box for "Use
wildcards".

Put this expression in the Find What box (there is one space between the two
groups):

([0-9]) ([0-9])

Put this expression in the Replace With box:

\1,\2

Click the Replace All button.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit.

 

[DeanH]

This should be:
([0-9]) ([0-9])
NOT
([0-9]) ([9-0])

This post is very useful, however when I type the serie with a space:
([0-9]) ([9-0])
I get this message
"The Find What text contains a range that is not valid"

Could you precise,

Thanks

Dear All,

I have data like this.

Additional paid-in capital 1 722 286 1 630 394
Accumulated other comprehensive income (loss) (890 446) 239 041
Retained earnings 40 026 498 40 611 396
-----------
Can you please tell me how I replace the spaces in amounts with comma
without replace effecting in descriptions. Only comma should come in amounts
only not in descriptions. I data should like this:

Additional paid-in capital 1,722,286 1,630,394
Accumulated other comprehensive income (loss) (890,446) 239,041
Retained earnings 40,026,498 40,611,396

Thank You
Narendra

Click the More button in the Replace dialog and check the box for "Use
wildcards".

Put this expression in the Find What box (there is one space between the two
groups):

([0-9]) ([0-9])

Put this expression in the Replace With box:

\1,\2

Click the Replace All button.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit.

 

[Von Stussi]

Thanks DeanH

This should be:
([0-9]) ([0-9])
NOT
([0-9]) ([9-0])

This post is very useful, however when I type the serie with a space:
([0-9]) ([9-0])
I get this message
"The Find What text contains a range that is not valid"

Could you precise,

Thanks

On Thu, 8 May 2008 19:42:00 -0700, Narendra Boga

Dear All,

I have data like this.

Additional paid-in capital 1 722 286 1 630 394
Accumulated other comprehensive income (loss) (890 446) 239 041
Retained earnings 40 026 498 40 611 396
-----------
Can you please tell me how I replace the spaces in amounts with comma
without replace effecting in descriptions. Only comma should come in amounts
only not in descriptions. I data should like this:

Additional paid-in capital 1,722,286 1,630,394
Accumulated other comprehensive income (loss) (890,446) 239,041
Retained earnings 40,026,498 40,611,396

Thank You
Narendra

Click the More button in the Replace dialog and check the box for "Use
wildcards".

Put this expression in the Find What box (there is one space between the two
groups):

([0-9]) ([0-9])

Put this expression in the Replace With box:

\1,\2

Click the Replace All button.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit.