remove characters

I have a need to delete leading characters (5) from the same column (D) across multiple worksheets. I can get it to work on a single spreadsheet using the following code: Sub RemoveCORP() Range("A1").Value.Activate For Each Cell In Range("D2", Range("D1000").End(xlUp)) If Not IsEmpty(Cell)...

Hi I have the following info in cells a2:a5 Andrew Lee Jones Ken David Thompson Chris Smith David Stephen Scott I would like to keep the last name.. So keep, Jones, Thompson, smith, Scott Please coud you show me the best way of doing this

Hello, I'm new to the forum, but I use the site for help all the time. Usually I am able to figure it out based on other issues threads, but this one has me stumped. I am looking to run two subs, one to remove extra characters on the barcode scan itself (see below for code). Private Sub...

<tbody> This is what i have: (The 0 and CA are on one line- 4 lines total) 000433821517 00114427 0 CA 000645000670 00234411 0 CA 000790810056 00229763 0 CA 000901000017 00068794 0 CA </tbody> This is what I want (keep...

I have a large no of strings(left hand side of arrow) and i need to convert them into Date format(right hand side of arrow) in Excel. 19,690,408 --->> 04/08/1969 19,610,419 --->> 04/19/1961 19,560,107 --->> 01/07/1956 Can anyone help me with this? Thanks in advance.

I have a spreadsheet showing variable strings however I want to remove all character that appear after / e.g 'Virgin Islands/123/7 H %' should appear as just 'Virgin Islands'. The strings and the characters after the '/' are variable in length so the replace function using '/????' will not work...

I have a form that the user browses to a workbook and imports all data from columns and then once the workbook that was opend is finished with it closes. however if the user closes the userform with the red X id like the workbook that was opened to close. I want to exclude the workbook that we...

Hi all, I am writing a vba program that needs to take data from an excel table that was converted from a pdf file and then process it for my specific needs. The processing of the data isn't important to my question. The problem I have is that when this pdf table is converted to an excel table...

This is frustrating b/c I'm not Mr. Excel, but I have a TON of numbers to go through and they all have dates and times in the same cell... how so I just get the numbers by themselves (easily) so I can do simple addition? Thanks, Cushlapper

Hi I have to remove space and/or points from cells with a VAT number , IBAN and swift in exel sheets. (3 or 4 cells on the sheet) How can I do this with VBA. Thanks in advance for your help Regards Al

Hey Everyone, I am a total excel noob how can i remove the last 19 characters from a field for example: <table width="652" border="0" cellpadding="0" cellspacing="0"><col width="652"><tr height="20"> <td style="height:15.0pt;width:489pt" width="652"...

Is there a way to remove certain characters from a userform textbox, i.e. like the find and replace on a worksheet. I don't want to copy the data to a cell on a sheet first as I have a selection change event which interferes with things, I would prefer to be able to do the changes within the...