You don't need a special character in the CSV. Just search for (?<=:). and replace with <space>$0 in the merged file.
Thanks, but I already wrote <space> into the .csv fields where I need spaces. Sometimes I just want a space and it doesn't necessarily come after a colon. However, that's not really the problem I'm trying to figure out.
1. The recplacement needs to work across all records, not just the one I'm currently previewing.
2. The replacement doesn't stay replaced when I do the actual merge.
*Just so I'm understanding you right, by "search" are you referring to the "find what:" and "replace" are you referring to "Change to:" in the Find/Change Window?
Make sure you set the scope for the find/change to Document. It may have defaulted to Selection or Story.
I see now, I need to do it after completing the merge, not before. Problem solved, back to data entry. Thanks again Mr. Spier.