bmsolis1
Level 1
11-18-2020
11:53 AM
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- 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.
Solved! Go to Solution.
1 Solution
Accepted Solutions
Happy-Tax
Level 4
11-19-2020
08:30 AM
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- 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.
2 Replies 2
Happy-Tax
Level 4
11-19-2020
08:30 AM
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- 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
- Email to a Friend
- Report Inappropriate Content
Thank you.