character string

Hello, I Have the below kind ot text that repeats over 100-200 lines: 8-LL-001D-RJS / MSIAG-01 - (GI) 1 tramo - ESPECIAL 8-LL-014D-RJS / MSIAG-02 -(GI) 1 tramo - FL 3-RJS-739 (PO) - 7 tramos and many other "X-XX-XXX - X tramos" I need a new text which is always the words left to the left of...

Hello to all. I have a macro that allows me to select a folder and then save that selected location as a variable in a String format. Sub SelectFolder() Dim SourcePath As String MsgBox "Please choose the correct folder", vbQuestion, "Folder" Application.DisplayAlerts = False...

Hi - I have a column which has names of businesses but some of them have the zip code attached to them. For example most cells are just ABC Company 123 Company Def Company But some are ABC Company90210 123 Company10011 Def Company20007 In all the cells that have zip codes, they are always 5...

I am new to Excel VBA or Macro,I have the following Excel problem: Need Macro to do the job I have a large excel spreadsheet with alpha-numeric data. I want to be able to compare two cells in different row side by side and return the difference in another cell. e.g. I have in cell B2, "tom...

I have a lot of data (circa 6,000 rows!) to clean. In the date/time cells the entries appear as a text string like this: 2011-01-30T00:33:54.67 I need to separate it into two separate entries – one for the date and one for the time. So for example <TABLE style="BORDER-BOTTOM: medium none...