how to add dashes between words in a cell - Excel Help Forum
Nov 9, 2015 · Re: how to add dashes between words in a cell did anyone figure out how to do this. I need to put dashes between the words; instead of spaces.
Add dashes before and after text to fill cell - Excel Help Forum
Jul 20, 2015 · Re: Add dashes before and after text to fill cell Hi Dave, the formula works, but it only adds a few dashes (2-6 depending on the length of my text), and does not fill the entire cell.
Reformat SSN to add dashes between numbers - Excel Help Forum
Jan 17, 2013 · Re: Reformat SSN to add dashes between numbers Hi wheatgrass Insert a new column (assume Column B) with your original numbers in Column A. Enter this formula in …
I see a dash, Excel sees a minus sign. - Excel Help Forum
Nov 9, 2009 · Hi, In one cell, I have a line of text beginning with a bullet. I want to change the bullet to a dash. But when I replace it and click off the cell, the first cell seems to want to preform …
Adding dashes to a number - Microsoft Community
Nov 18, 2013 · Adding dashes to a number Hi all, I have thousands of numbers i need to add dashes to in Excel.... Basically, the numbers i have to work with look like: 3301AXRE152031 …
How to generate 16 digit unique random alpha numeric numbers?
Feb 11, 2016 · Re: How to generate 16 digit unique random alpha numeric numbers? Thanks for this code.. Any help to add dashes in between strings on the 9th, 14th, 19th, and 24th …
how do i enter a date quickly without using slashes or dashes?
Aug 7, 2014 · Re: how do i enter a date quickly without using slashes or dashes? With your cursor in the cell you want to do this or the column highlighted if its the entire column - right click - …
Add dashes to fractions in html - Excel Help Forum
Jan 12, 2017 · Re: Add dashes to fractions in html Could you tell me how you paste all code into excel? I copied and paste it from your post and have every code line in different row. One line - …
How do I add a 0 and 2 dashes to a truncated soc. sec.# in a cell
Jul 7, 2006 · How do I add a 0 and 2 dashes to a truncated soc. sec.# in a cell I have a spreadsheet that has social security numbers (SSN) in a column. The numbers are missing the …
Zipcodes - some 5 digit, some 5+4 - formula to insert a dash
Mar 6, 2008 · I have 7000 + addresses in Excel from a database dump. Some addresses have the standard 5 digit Zip Code and some have the 5+4 Zip, but the dash is not included. I need to …