text to columns

Hello, I'm trying to create a macro in VBA which should convert all cells from B2 and downwards into mutiple columns. I got 8 sheets called D1, D2, ..., D8 - which all need to be affected by this macro. The character to seperate will be a comma. The macro will seperate dates from each other...

Good morning I have a column containing: Street Address (Alt+Enter for line break) City State Zip (Alt+Enter for line break) Country I am attempting to use Text to Columns to break this entry to three columns, but cannot figure out how to use Alt+Enter as the delimiter. Thanks in advance!

Hi Everyone, Need Some help. I have sheet with Title + Company in single excel cell. There are about 590 Rows. Examples Owner at SPP Company CEO and President at Zisoo Co INC Principal of ILT PVT Limited. Founder and Managing Director - IPKA Tel INC As you can see I cannot use Excel Text to...

Hello, thanks in advance for your help. I have data exported from Outlook in 3 columns: To (address), To (display), and To (address type) I want to do a text-to-columns and transpose such that each address (separated by a ";" in all three columns) gets it's own row. Easy enough to do if all...

Hey there, I got a major problem with my dataset (500+ rows) and since I am not an Excel Pro and couldn't find answers on the internet I am posting my first ever question online: Okay here is the issue, I want to put every number of this column in another cell, like I did it for the first two...

Hi, I'm trying to get the names in row C of the screenshot into two different columns, ideally, I'd like to have the content in every cell from row C listed the way they contend from C1 is now listed in cells D1-4 and E1-4. Let me know if you need more information. Screenshot URL: Image -...

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

Hello, Excel Gurus! I have some data like below in the first image and I want to change it to like the second image by using a macro. In the real table there are a lot more columns and rows, but columns who should be made "text to column" and "transposed" are two: Product Color...

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

let's say I have a cell A1 contain 2 values input as (1,3/4), I want to separate the values into other columns like B1 (1) and C1 (3/4) using the Text to Columns delimited feature. However, it keeps showing me as C1(4-March) even though I formatted original cell to text format already...

Hi, First time on this forum so looking forward to improving my Excel skills here. I'm not an Excel newbie but I'm not an expert either. I've been building a tabular dataset using results posted on ResultsDB detailing English Premiership football results going back to season 2000-01. The...

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

Hello, I'm trying to do what is typically done within excel using the "Convert Text to Columns" wizard (Delimited) and a "Paste Special - Transpose" function within Access. For example, within the form in access, I have several dates listed, seperated by a comma (1/3/16, 1/5/16, 1/6/16...

Hello Excel experts, This is my first post here. I need your help in solving an issue with separating out addresses into address, city, state and pin code. This is how my data looks now. <tbody> <colgroup><col></colgroup><tbody> 503, LEVEL 5 , BLOCK A KELANA CENTRE POINT 3, JALAN SS 7/19...

Hello, I have a large number of addresses which have been put into one column. I need to split up the addresses in order to put together a mail merge file. The problem is that there are too many individual words for the normal text to columns function to work eg one address might be c/o Mrs M...

Excel version: 2013 Problem: Hi everyone! I'm an economics student researching for my master thesis on 3D printing, I was trying to create a database of 3D printers with various informations (Company, Model, Materials etc.) where 1 material coincided to one row. My problem started when I...

I have a survey with a significant amount of open ended questions. It order to code the survey I need to split each section of each open ended response into one cell. For example, the single cell: "Service was slow and I hated the food" would become two cells, "Service was slow" & "and I...

Hello all, I have a question I have not seen answered yet, and I have no idea how to accomplish this. I have some data which shares some common elements, but has unique values. Some cells have multiple items separated by a linefeed (Alt+Return) as in the description column. For example I would...

Hi there, I am trying to separate 160 rows of data into columns. Each piece of data is separated by a | currently, however between clicking next after step 1 and step 2 the majority of the data disappears and when I click finish only 2 pieces of data from the cell have separated and the rest...

Hi All! I'm new to VBA so apologies if this is more straightforward than it seems. I have a spreadsheet which is used to automate some report formatting and create graphs for an end user. The end user exports the required reports from our database, pastes them into my workbook and my macro then...