How do I check for a blank cell in a range and replace them

At the point of creation of the Excel csv file. The reason to make it a bit clearer is that we are creating a template of a file for uploading information to a database. When we create the file and convert it to a pipe delimited file using the excel .csv format the last field in the file is one that we do not always populate and it is not included in the csv file. Excel appears to consider it a blank not used field and does not convert it with a pipe on the end. We could simply add the pipe in the txt file but it would be easier if it was just created when the upload file format is put into the template spreadsheet. I was looking for a way to generate the filler character for the field when our data person has finished putting in the data including any in this field. I have found the Find/Replace that just replaces the blanks and that might be our best option but I am just making sure that there is not a better way, thanks!