Removing letters in a cell

Originally Posted by teylyn

Select the column. Hit Ctrl-H to open the Find and replace dialog. Enter

Find what: UN
Replace with: leave empty

Click Replace All.

Just like butter.

Thanks.