bmsolis1
Level 1
11-18-2020
11:53 AM
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
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.
Best Answer Click here
Labels
Happy-Tax
Level 5
11-19-2020
08:30 AM
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
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
Level 1
11-20-2020
09:24 PM
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Thank you.
