Hi Everyone,
Is it possible to search two fields with one find and replace?
I know I can run one find and replace into another and search twice, but I end up with two fields appended to the end of my spreadsheet.
If it is not possible to search two fields with one find and replace, does anyone know how I can merge the two fields into one with only a single value in the remaining field?
Thanks,
Dan
Solved! Go to Solution.
@DanMBrx I think the find and replace tool is able to search for only one field, if you want more fields to search you need to use another find and replace. For your use case can you provide a sample test file and the expected result?
Thanks @binuacs great help once again.