Excel tutorials

The only Excel books you will ever need

  • The only constantly updated Excel 365 titles more…
  • Thoroughly covers Power Pivot and Power Query more…
  • Covers business intelligence and OLAP features more…
  • Simple, easy, understandable, 2-page lessons more…
  • Available as both printed books and e-Books more…
  • Used by schools, colleges and universities  more…
  • Available for 365, 2021, 2019, 2016 and Mac versions more…

Remove dashes from ssn, keep zeros

remove-dashes-from-ssn-keep-zeroes

This article shows you how to remove dashes from social security numbers by using Excel’s SUBSTITUTE function, with a downloadable example.

Which tutorial do you need?