clean

  1. sharky12345

    Clean up project without addin

    I need to find a way to clean up a project without using an addin. When I say clean up, I mean like removing empty lines etc - I also need something that could add or remove line numbers if possible. I was thinking is there something like a module or function that could perform this. The...
  2. A

    Sort and eliminate blanks

    Hello, Newby quesiton here to keep you on your toes! ;) How would I clean up a list in a column refered to by a named range, and copy the results to another column? In other words, I have a list of fields whichm based on a vlookup, returns cities (or not) to column A. This list sometimes...
  3. D

    Clean and Trim Data from a column without removing alt-enter.

    Hey, As my last post regarding is not addressed I am posting this again. I want to clean (removing non-printable character) and trim (removing extra spaces at the beginning and end) my data in selection within a column. As the clean function also remove alt-enter, I want alt-enter to be...
  4. D

    Clean and Trim data from a column

    Hi, I am trying to clean or trim my data in a column. My objective is to remove all non-printable characters and also the leading and tailing extra spaces or the ALT-enters. The code I have written also removes ALT-enters in the middle of the data :(. Please find my code below: Sub CleanTrim()...
  5. N

    Unidentifiable Non Printing Character

    Hi, I have a spreadsheet which has data imported from a very old excel format (excel 2.0). There are cells in this file which appear blank however excel 2017 does not perceive them as such. The really odd thing here is that if i use F2 to edit the cell and then hit enter or Tab to move off of...
  6. P

    How to do this?

    Hello, so basically what I'm trying to achiveve, I barely have knowledge in Excel, but It'll make my life much easier. https://i.imgur.com/eu5vWgS.png So at the moment, there's a reason if it's blacklisted or not, the email, so if it's clean it'll just type clean. So what I'm trying to grab...
  7. L

    separting text to cloumn

    Hi I have this sheet (please see the link below) and I want to separate them into columns. Text-To-Column did not do the right job. Is there anyway to do clean separation in case like this. Thanks a lot. https://docs.google.com/spreadsheets/d/11opqWXTJ1-N2-yFID7yjMWjnJCNO85nV/edit?usp=sharing
  8. E

    Object doesn't support this property or method

    If I enter the following code into the ThisWorkbook object in a newly created Excel document: Sub Clean (ws as WorkSheet) MsgBox ws.Name End Sub Sub test() Clean (WorkSheets("Sheet2")) End Sub I get the error "Object doesn't support this property or method". What do I need to do...
  9. D

    Certain cells to be entered before my userform can be triggered.

    Hi, I have a form that works in rows and row 5 is the first row with a clean in. I have 3 different types of cleans and they are determined by what letter is in column B. I want different cells to be entered within the cleans before the userform in column AP can be triggered. Cleans are...
  10. B

    Macro to clean cells of invisible spaces and trailing/leading characters

    I have a huge spreadsheet of 77 columns and close to 78,000 rows that I need to run the clean and trim functions to clean the data. Is it possible to create a macro that will both clean invisible characters and leading and trailing spaces. I can't use spreadsheet functions because I have to too...
  11. B

    Using Find and Replace, macro to physically reformat a cell to comfort to 1 type of format

    I'm working on a project where I might have to a macro run at a specific time of day. The data I'm using is coming from an external database where a number of fields have data that is not formatted properly. For example, in the primary telephone field I have 32 different formats. I need to...
  12. rjplante

    Clean spaces and returns when leaving a cell

    I have a single 10 character block of text that is copied from another location and pasted into cell B2. It almost always contains leading and trailing spaces as well as a carriage return. I would like to have the user paste the value into the cell and when the hit tab, or the enter key to go to...
  13. E

    Clean up Code

    So I have this vba code, but it seems pretty redundant. I'm not that good at VBA yet, so could anyone could help me clean this up? Sub GetSheets() Dim Path As String 'FolderName gets directory of folder Dim FolderName As String With Application.FileDialog(msoFileDialogFolderPicker)...
  14. S

    [VBA] clean up empty code line in VBE under Sub / Function

    Very Often I create many blank codes lines during VBA coding. Is there available add-in to clean up those empty lines, to generate a more neatly-aligned VBA code? Thanks! e.g. Sub XYZ()  Dim A as Integer  (empty)  (empty)  A = A + 1  (empty)  MsgBox A  (empty)  (empty) End Sub Thanks a lot!
  15. H

    How Can I Simplify the attached Formula -

    Hello - How can i clean the below formula - =SUM(COUNTIFS(State,{"CT","DE","PA","NJ","DC","MD","NH","OH"},Value,">10",OFFICE,"Name1"))+SUM(COUNTIFS(State,{"CT","DE","PA","NJ","DC","MD","NH","OH"},Value,">10",OFFICE,"Name2")) Please help thanks
  16. C

    Help Cleaning up VBA Code to Run Faster/More Efficient

    Hello Everyone, I've been working and building this current script. Currently it averages between 2.5-4 mins to run from beginning to end (sometimes longer). I've searched online and have added such pieces as preventing screen refresh, but still falls within the 2.5-4mins range. Can anyone...
  17. W

    Clean the sheet by rows

    Hi All, I am so noob with excel, so I would be glad if somebody could help me. And I hope that you understand my English L I need a macro to clean my excel sheet and reorder it: First, I need to take off all rows what do not have in column D project number (the project number is...
  18. F

    Clean/Trim during data import

    Hi, I'm copying data between two excel: ... For i=2 to rows_x TEMP_city = ws.Range("B" + CStr(i)).Value 'this value can contains space wsSC.Range("A" & AT_rows).Value = TEMP_city ... next i ... How can I during this process use Trim or Clean function, to delete "space" etc.??
  19. L

    Clear ONLY cells that contain a formula that evaluates to "" using VBA

    I've searched rather extensively but can only seem to find the OPPOSITE of what I'm trying to. I want to use VBA to evaluate all of the cells in a given range on a sheet and delete the contents of any cells that have formulas that evaluate to "" We are using this spreadsheet to upload to a...
  20. G

    Data from another worksheet won't automatically change into desired format (Accounting)

    I'm using Microsoft Excel 2010 on Windows 7 64-bit. I have a worksheet where I have different products with their prices from 2 different stores. I have 3 worksheets altogether - this front one where I can see the stuff I need, one for one shop, and one for the other shop. For each product I...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top