About 50 results
Open links in new tab
  1. Moving dotted line not going away | MrExcel Message Board

    May 11, 2016 · Re: Excel - Moving dotted line not going away Let me provide some backstory on this. The behavior changed for Office 365 customers starting in June 2017. Acting in response to this …

  2. Remove annoying dashed lines from Excel sheet

    Jul 16, 2008 · Hi Somehow I got dashed (dotted) lines all over my Excel workbook. I think they are indicating print layout or something. How do I remove these? I've searched the internet without …

  3. How to remove green markers? | MrExcel Message Board

    Mar 8, 2007 · Hello, I've been given a spreadsheet to maintain at work. There are green notches (or markers) in the top-left corner of several cells, but I can't figure out how to remove them. What are …

  4. Can't get rid of dash in blank cells | MrExcel Message Board

    Mar 7, 2005 · I have a spreadsheet that shows a dash in some blank cells and I can't get rid of it. Cells are formated as general, there's no event code, no conditional formatting, no data validation, no …

  5. Remove Dashes in SS#, Leave Leading 0 and keep it in TEXT ... - MrExcel

    Mar 18, 2010 · I am trying to remove the dashes in a column full of social security numbers but I also want to leave the preceding "0" if the social begins with such. The different formulas that I have tried …

  6. Removal of dashes and spaces | MrExcel Message Board

    May 28, 2002 · Is there a way to remove dashes and/or spaces from a string of numbers in the same cell? eg. 123456 instead of 12 345-6 thanks

  7. Taking out dashes | MrExcel Message Board

    Jan 26, 2006 · Does anyone know how to get rid of dashes in a number. Like if I had a number that was 2990-01-192-6805 what would I do to get rid of the dashes?

  8. Formula to remove a preceding 1 from a phone number..

    Jul 23, 2015 · Hi all, i'm working on formatting massive amount of phone numbers at a time and have run into a little snag.. when I get these numbers they come in many different ways, but I need them …

  9. How do I get rid of Page Break print preview dotted lines

    Nov 12, 2010 · I clicked on "View" "Page Layout" in order to set View Ruler. As a result, the dotted page break lines appeared on my spreadsheet. How do I get rid of them?

  10. Removing dashes and (sometimes), dots in telephone numbers

    Apr 17, 2006 · I have imported data that has some telephone numbers as 10 didgit numbers with no hyphenation, some that are hyphenated after area and local code and some that are seperated by …