Excel Gurus: Need SSN function help - Techist - Tech Forum

Go Back   Techist - Tech Forum > Computer Software > Microsoft Windows and Software
Closed Thread
Thread Tools Display Modes
Old 11-07-2005, 03:22 PM   #1 (permalink)
True Techie
Join Date: Apr 2005
Posts: 188
Default Excel Gurus: Need SSN function help

I got huge reports with the SSNs containing dashes. How do I remove them without having to go through each one of them manually? I know it requires a function and formatting the entire column.

I've tried setting the column to Custom (SSN), but it's not doing anything. What's the actual function to remove the dashes?

Last, how do I add an additional digit to that formula so that all SSNs are 10-digit starting with a zero?

Any help with this is greatly appreciated! :bald:

Seiken is offline  
Old 11-07-2005, 04:28 PM   #2 (permalink)
Junior Techie
Join Date: Jul 2005
Posts: 83

=RIGHT( "0000000000" & SUBSTITUTE(A1,"-",""), 10)


= "0" & SUBSTITUTE(A1,"-","")

Jamil is offline  
Old 11-08-2005, 08:01 AM   #3 (permalink)
True Techie
Join Date: Apr 2005
Posts: 188

Thanks for the help!
Seiken is offline  
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Our Communities

Our communities encompass many different hobbies and interests, but each one is built on friendly, intelligent membership.

» More about our Communities

Automotive Communities

Our Automotive communities encompass many different makes and models. From U.S. domestics to European Saloons.

» More about our Automotive Communities

Marine Communities

Our Marine websites focus on Cruising and Sailing Vessels, including forums and the largest cruising Wiki project on the web today.

» More about our Marine Communities

Copyright 2002-2015 Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 01:13 PM.

Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2016, vBulletin Solutions, Inc.