Excel 2007 : Editing Cell Data

[saunderd]

I have a very large spreadsheet (over 10,000 lines) with Column C “Last Name” and Column D “First Name”. I did a “ =CONCATENATE” formula to put many of the Last and First names together into one column for a different project, i.e., “Smith, John” , but when I split them apart again using the “Data, Text to Columns” function to return them to their original configuration in 2 columns, there is a “.” at the end of the Last Name now. Is there a way to eliminate the dot from the end of the last names without manually doing each entry? The way it is now, this screws up the sort, as some Last Name entries for Smith have a dot and other line entries for the same person don't have the dot. I am looking for a way to remove the dots from those lines that have them and leave the ones alone that don't.

[khamilton]

Find and replace. find "." replace with nothing.