Fellow Forum Members,
I have close to 2,000 rows of table data that looks like this:

. Power Supply. . .. .............
.. Washer........................


.. Bolt. . . . . . . . . . . . . ... .

The need I have is to get rid of all the PERIODS and SPACES located to the RIGHT of the text.

However, the PERIODS and SPACES located to the LEFT of the TEXT needs to remain intact (these PERIODS and SPACES are manually typed in and are there for the purpose of showing assembly hierarchy).

All the spaces and periods located to the RIGHT were also manually typed in to represent leading dots. Therefore, they are not consistant and incorrectly done. Some rows have spaces in between the periods and some rows do not. Nevertheless, all these manually done leading dots need to be deleted and replaced with leading dots setup through a TAB Style Definition setup.

What is the correct Wild Card formula that I could use with the Find & Replace tool that will accomplish the task of just deleting the PERIODS and SPACES located only to the RIGHT of the TEXT? Any help will be greatly appreciated. Thanks.