trimming

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...

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 ...

any assistance would be really appreciated , thanks !

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...

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...

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 =...

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...