trimming

  1. L

    Doing both right and left trims in the same cell at the same time

    I have successfully used RIGHT/LEFT/LEN/MID in the past but can't get this one to work. I have a text string with numbers I want to extract but the text in front is varying lengths whereas the text behind is the same length. The numbers are enclosed by brackets with should make it easier but...
  2. F

    Need to trim various prefixed that are in ALL CAPS off of text in a column

    We have song titles in a column that have ALL CAPS prefixes that we use internally to identify the writer/origin of the song. For example: RSCAT TR Let The Sun Shine In RSC GHT Night Runner RD FGH Midnight Mountain I need to trim the ALL CAPS gibberish off of the front of the titles ...
  3. F

    Formula for removing characters before or after a specific symbol or phrase

    any assistance would be really appreciated , thanks !
  4. Grizlore

    Speeding up this once speedy code

    Could anyone suggest how I can speed up this code please? This used to work really quickly, however on my new quicker 'laptop' it takes ages. I can see in the bottom Excel bar it displaying Calculating (4 processers: x%). Which I have never seen before! Anyway.. here is the code Sub...
  5. E

    Select part of input range

    Hey folks! So I'm programming a function that takes a range as input but during the course of the function I need to use a subset of this range as comparison. So if I get a range("A20:A46") as input I need get the range without a few of the cells at start and end, so something like...
  6. Grizlore

    Simply... why isnt this TRIM() trimming please?

    Hi all, I am having a stupid day... and can't see why this isn't working... Simply... why isnt this TRIM() trimming please? Private Sub CommandButton1_Click() Dim sapFARM As String sapFARM =...
  7. C

    Trimming Blanks using VB

    Hi All, I have a data set of about 20k rows, exported from a not so friendly DB, that has blanks all over. It is causing havoc with my VB and Dates! Can anyone help me to TRIM all the data. Ideally some VB just to pop into the clean up loop I have on for formatting. Any advice would be...

Watch MrExcel Video

This Week's Hot Topics

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
Top