clean trim

  1. Manolocs

    error clean spaces formula

    Hello, for some reason this formula clean one space only in the cell, I have to use the formula several times to get ride of all spaces in the cel :(. Can someone help me? Thanks in advance.... =TRIM(CLEAN(SUBSTITUTE(A1,CHAR(160)," ")))
  2. M

    Splitting an Address equally in 2 columns

    Hi Everyone, First time poster, hope I am following all the rules. My dilemma right now is: I have an excel with around 3000 office addresses all in a single column, I need to split this in two (i:e, Address becomes, Address 1 and Address 2) For EG: <tbody> Address Address 1 Address 2...
  3. 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.??
    • Forestq
    • Thread
    • clean clean trim cleaning data trim trim macro
    • Replies: 2
    • Forum: Excel Questions
  4. F

    CleanTrim function

    hi, I'm using CleanTrim function wrote by Rick: Trim all Cells in a Worksheet - VBA but I got Run-time error `1004` Application-defined or object-defined error after 1774 recrods my code below Dim sourceWb As WorkbookDim LastRow, x_rows As Long Dim i As Long Set sourceWb = ActiveWorkbook...

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