CSV View

[bmsolis1]

I’m creating a csv view from Homebase but it creates the SSN column in NNN-NN-NNNN format.  I need it in numbers only without dashes. Does anyone know how to do this? Thanks.

[Happy-Tax · Accepted solution]

Create the .csv file and view it in Excel. Copy the SSN column into another worksheet. Use the Find and Replace command (Ctrl-H) to replace the hyphens with nothing, thereby removing the hyphens. Then copy the column back into your .csv file.

[bmsolis1]

Thank you.