![]() |
#1
|
|||
|
|||
![]()
Yesterday I was faced with the challenge of adding a dollar sign to all the number amounts in several columns of a several-page-long table. First, I figured out how to use wild cards to do it for any number of 2 or 3 places. (All numbers had 2 digital places, but this seemed irrelevant to me purpose.) However, while perhaps a dozen of the numbers were only three places, e.g., 306.54, most of them were in the thousands or ten-thousands, with a comma. I found that my search formula then jumped to the hundreds places, e.g., 13,576. Then I determined how to change the search to look for these larger numbers, following my first parenthesized term with a comma and then using a second parenthesized term with {3}, but then it would not work for those only in the hundreds.
Is there a way, using wildcards, to find both in a single search? |
#2
|
||||
|
||||
![]()
Find
<([0-9,]{1,}).([0-9]{2}) Replace $\1.\2
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#3
|
|||
|
|||
![]()
Thank you, sir!
|
![]() |
Tags |
numbers, tables, wild cards |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
thefonebug | Word | 12 | 10-24-2016 05:18 AM |
![]() |
DeniseN | Office | 1 | 03-20-2015 01:13 AM |
![]() |
mbenton | Excel | 10 | 01-27-2015 09:13 AM |
Word table - how do I append % symbol to each value in columns 3 & 4 of a table | Dawsie | Word | 4 | 03-06-2013 12:33 AM |
![]() |
jetdude68 | Word Tables | 1 | 07-20-2010 12:30 AM |