text to columns vba

Dear All, I currently have a setup that looks approximately like this: I would like to know if there is some record macro / VBA solution to separate the emails so email 1 goes into Column K, email 2 into column O and email 3 into column S? I tried to record a macro and use "text to...

I have data in the below format - Col A1 Col A2 Col A3 Col A4 Col A5 Col A6 Col A7 Col A8 Col A9 Col A10 Col A11 Col A12 Col A13 Col A14 Col A15 Col A16 Col A17 Col A18 A B C 1,2,3,4,5,6,7,8 D E F G H I J K L M N O P Q I need it to be this way - Col A1 Col A2 Col A3 Col A4 Col A5...

I have a .txt file that shows various information in sections about production orders. I can easily identify the sections of information, but the information will usually be just a little different, but in the same relative format. When I highlight a section and click text to columns, it...

I was recently handed in a text file I am trying to create a spreadsheet or CSV from the contact information. I have noticed that I have "missing spaces" and cannot find a method of shifting the cells to properly store the details. I have included the following as an example of the text...

Hi. Could use your help in figuring out proper VBA code to use on a per entry basis, row by row. Entry is from left to right along the row from “Date” to “Receipt #”. When it gets to the end of the row, that VBA code should return to the “Description” cell for that row and then execute “Text to...

Hi all, Currently I have the code below, which converts text to columns. I paste the text (with multiple rows) in cell A1 and run the macro. Sub TextToColumns() Columns("A:A").Select Selection.TextToColumns Destination:=Range("A1"), DataType:=xlFixedWidth, _...

Hi all, I have the code below now, but when I manually hide a column (for example column C) and use the toggle button twice, column C is visible again and I want it to stay hidden. Is there a possibility to do that? Private Sub ToggleButton1_Click() Dim xAddress As String xAddress = "A:Z" If...

Hi All, I have been given a data set that was poorly converted from a pdf file which I'm left trying to clean up. All of the data is in column A and each line of data is in a single cell. Example: A1: A1A# ST. JOHN'S NL STN MAIN B1G DOMINION NS STN MAIN B3Z TANTALLON NS STN MAIN A2: J1S...

I have searched the forums here and cannot find a solution that makes sense to me, so here goes- I have data from a query. It is in table format and I need to format two columns. The first is a list of stock numbers. Some contain only numbers, some have alpha characters at the end. i.e...

Hi All, I have a set of First Names and Last names in my application in below format. When i am using text to columns, i am getting output as But, I need output as below : Can someone help me to get the required output? or else please let me know at least, is it possible or not...

I have a large string of text: 01/10/13 / Free Estimate on repair vs replace on opener / son will be home to let you in, call Nick when you are on site to go over recommendation ~VNL**Chris / 15 year old craftsman 1/2 belt with stripped gear.Told him his options and he said he wanted to do the...

Thank you in advance for anyone willing to solve this problem. I'm in need of a solution for an excel file in which each cell within two columns labeled, "Primary Diagnosis" and "Secondary Diagnosis" of a 100 column worksheet contain multiple ICD-9 or ICD-10(Industry Standard Diagnosis Codes)...