text to column

Hello All, I have a column of seat (arena) data. The data contains section numbers and rows. I want to extract the section numbers into 1 column and the row (letters) into another column. Here's an example of my data set: <colgroup><col></colgroup><tbody> 104 BB 103 & 105 BB 104 CC 103...

Hi Folks, I am trying to convert values in one column by using Text to column. Strange thing that is happening is that last digits of value are being converted into some another value.Sample is given below: Book1ABC1REGISTRATIONTEXT TO...

I have data that is formatted like so... <tbody> calldate 12/12/2015 18:52 12/12/2015 16:50 12/12/2015 16:17 12/12/2015 14:00 12/12/2015 13:44 12/12/2015 13:35 12/12/2015 13:11 </tbody> I'm running a macro, and one part of that macro is to separate the date/time column into...

So I have to create a macro for a project that's due no later than 2 days from now. The first part consists of splitting the contents, which Text to Columns normally works well for but not in this case since it is a large data set and doing touch-ups afterwards is a long and tedious process. I'd...

Hello, I have a problem when opening CSV files and the data is all jumbled. I would like to open the file and have the data sorted like 'text to columns' but without doing it manually. I did create a macro to remove the delimiter but I need to simplify the process even more. Any help is...

I'm trying to create a dynamic text to column but i have no idea how to do this. Basically I have a cell that will contain quantity and sizes of apparel and may look something like this: 20/s 13/M 14/L I can do a text to column that will pull this information out into individual cells to...

Hi, I am trying to use Text to column in VBA but when i run through a macro it doesn't seem to perform the function. I am using this so dates are in the right format for conditional formatting in other cells. below is some code. the amount of rows in the column can vary so i have used...

Hi, i am trying to convert the text file (extracted from an old database) into excel. Unfortunately i am unable to preform it as a single row data is divided to multiple lines, and then the page break. I once remember one of our IT expert provided me a solution with a similar problem using xmls...

I'm not sure what I'm doing wrong. I've tried multiple things and looked at different threads, but i still get the Run-time Error '1004'. I'm just trying to do text to column for range A:A in Sheet "LY". This is the code I've been using Sheets("LY").Select Selection.TextToColumns...

Hello All, I need to convert a text string to columns. The fields of the string are bifurcated with 3 to 4 spaces each. However the string contains "Name" and "Address" fields which naturally have spaces. When i use to option text to column using spaces it takes every word of name and address...

Hi all, Im trying to figure out how to loop below codes. I may have more than 60 list of materials though. appreciate if anyone can help.:) 'Material 1 Range("A2").Select Selection.TextToColumns Destination:=Range("B2"), DataType:=xlFixedWidth, _ FieldInfo:=Array(Array(0, 1)...

I looked around and cannot find a macro to cut the last character from a cell and put it into the next cell over. I would just use the text to column function but there are no common deliminators or text length. For example: <tbody> 9000600B 8475A 900655888A 741548C 300B...

I wished I was better in VBA because I've been searching how to solve this problem since last friday. I'm hoping you guys can help me out or put me in the right direction. Basically what I need is to find a way to Text-To-Columns, in a fixed range, but only for cells that contain spaces. I...

Hello I have a spreadsheet where the zip codes have been merged with other numbers making them invalid For example, the actual zip code should be 37027 but for some error the ZIP appears as 370275378 I would like to know how I can split these numbers after five characters so that 370275378...

Column A has data e.g. cat is fat xy>zzy, dog is random xyzzy, rat is a hoax.set xyz, frog is alon.23e xyz, bullseye.8 x.z I have a look up table as below Col D xy>zzy xyz x.z (Note: the values in Col D do not have a set number of characters, so I cant use a Right/left Formula) I need...

I have an excel sheet that I need to separate out. I've already got the city/state issue solved, but I have a "name" cell that contains varying data ie) a1= Dr Joe Smith a2= dr and mrs john adams a3= mr greg j. Johnson I need to separate it out as simply as possible....any suggestions? I have...

Because Access doesn't support text to column, I've created a linked workbook. Now what I want is that when the workbook is opened, a macro is run automatically, then the workbook is closed and saved, also automatically. The macros I have found are: To run the macros Private Sub Workbook_Open()...

I need a macro that would copy some data from say A1 on Sheet 1, then paste it on A1 on Sheet 2, then perform a text to column, delimited by space. Is this possible? Thanks a lot

Hello everyone, I have a long list of company names. Each company's name has got combined like "AstroPhysics" instead of "Astro Physics". Can anyone help me how to separate combined text by reference to where a letter appears in upper / lower case? Thanks & Regards, Talha

Howdy! I just want to put out my supreme appreciation for everyone on this message board, yall have be invaluable to me as I work on a project assigned to me at work. Here goes my problem: We use a company wide system that tracks a lot of training statistics for each individual person (name...