Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
search-replace
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 |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
search-replace
On Thu, 8 May 2008 19:42:00 -0700, Narendra Boga
wrote: 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 FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
search-replace
Dear Jay Freedman,
Thank you for your instant reply. It reduced my time. "Jay Freedman" wrote: On Thu, 8 May 2008 19:42:00 -0700, Narendra Boga wrote: 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 FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Error message in the Find What
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 "Jay Freedman" wrote: On Thu, 8 May 2008 19:42:00 -0700, Narendra Boga wrote: 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 FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Error message in the Find What
This should be:
([0-9]) ([0-9]) NOT ([0-9]) ([9-0]) "Von Stussi" wrote: 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 "Jay Freedman" wrote: On Thu, 8 May 2008 19:42:00 -0700, Narendra Boga wrote: 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 FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. |
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Error message in the Find What
Thanks DeanH
"DeanH" wrote: This should be: ([0-9]) ([0-9]) NOT ([0-9]) ([9-0]) "Von Stussi" wrote: 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 "Jay Freedman" wrote: On Thu, 8 May 2008 19:42:00 -0700, Narendra Boga wrote: 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 FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search and replace - how to | Microsoft Word Help | |||
search and replace 1) and 2)...12) | Formatting Long Documents | |||
Search and Replace | Microsoft Word Help | |||
Search and Replace | Formatting Long Documents | |||
search and replace | Microsoft Word Help |