Skip to main content
Level 2
November 18, 2020
Solved

CSV View

  • November 18, 2020
  • 1 reply
  • 10 views

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.

This topic has been closed for replies.
Best answer by Happy-Tax

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.

1 reply

Happy-Tax
Happy-TaxAnswer
Level 5
November 19, 2020

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.

bmsolis1Author
Level 2
November 21, 2020

Thank you.