Share via

Find & Replace to insert thousands separators

Anonymous
2016-02-22T08:13:55+00:00

In MS Word I'm looking for the best way to use wildcard F&R to insert thousands separators (in this case an unbreaking space) wherever appropriate. The numbers in which they need to be inserted will be all be between four and six digits in length, sometime followed by a decimal point, sometimes just by a space, or the number may just appear on its own in a table cell. I will avoid using  "Replace all" to make sure that dates will not be affected.

Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

Paul Edstein 82,861 Reputation points Volunteer Moderator
2016-02-22T08:58:38+00:00

You could use a wildcard Find/Replace, where:

Find = ([!/-//][0-9])([0-9]{3})>

Replace = \1,\2

or, for replacement with non-breaking spaces:

Replace = \1^s\2

The above expression will ignore dates formatted with / or - separators.

Was this answer helpful?

1 person found this answer helpful.
0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Anonymous
    2016-02-22T10:06:51+00:00

    Thanks very much, Paul. That did the trick.

    The bit I was not familiar with was the ">" - which made the difference. Now I know that "end of word" also works for numbers.

    Was this answer helpful?

    0 comments No comments