Thread: [Solved] Excel 2016 Filter Help
View Single Post
 
Old 03-23-2017, 07:15 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Rather than change the data in the original column, copy the data to another column that you will use to edit. Thus you will have something like:

JLN:TRANSFER JLN:TRANSFER

which you will edit to be:

JLN:TRANSFER Transfer to John Smith

Thus you will still be able to filter the original data.
Reply With Quote