text to collumns

Hi all, I currently have a very messy sheet that looks like this: Essentially, row 1 is the heading, row 2-3 is the results that I want to produce through a text to columns, and rows 24-45 are the data that I currently have. The issue is that my cells have become messed up, so for every...

Hi all, I have a problem, I set up a macro to format a column (fixed-width) with a date format DMY. It works fine on my PC but on a colleague's pc, it isn't working. Here the code Columns("A:A").Select Selection.TextToColumns Destination:=Range("A1"), DataType:=xlFixedWidth, _...

We have a mess... We are using the newest version of excel on windows platform and have a massive list of email addresses that are unfortunately combined into one column in excel, the largest combination containing 157 email addresses in one column cell. Our objective is to move all of the...

Here is the Information that is in Column G surveyID=1053463&agentID=CV093V&chatID=745725784084061903&agentGroupID=10005201&VendorManager=Alec Pritzos...

Hello. My apologies if this was previously discussed. My work just switched me to a new computer. I am now running Windows 7 from XP and I am now on Excel 2013 from 2007. I am trying to import a fixed with text file to excel. I clicked on Data>Get External Data>From Text and attempted 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...

Data which i am having is as follows: <colgroup><col><col></colgroup><tbody></tbody> <tbody> Name Data abc 2,3,4,5 pqr 3,4,5,6,7,8,9 xyz 5,6,7,8,9 </tbody> Required Result Should look like following: <tbody> Name Data abc 2 abc 3 abc 4 abc 5 pqr 3 pqr 4 pqr 5 pqr 6...

<tbody> MERCHANT NAME ACCOUNT NUMBER CARDHOLDER NAME CARDHOLDER ADDRESS DATE AMOUNT ----CITY----COUNTRY---- MCC DECISION NOTES <tbody> 983764398764327 </tbody> <tbody> Doe, John L </tbody> <tbody> 123 Street Name </tbody> <tbody> 05/03/05 </tbody>...

I have a column of product descriptions with html tags embedded. I want to extract the beginning of each row up to the first html tag which is always . I tried running text to columns to split on '<' but because there are several html tags in each row, the rest of the text is not left in tact...

Hi all, Very good evening... I have an excel stock price template, where I need the current price to calculate the mid point if the chart. This is the text I get from the webquerry Underlying stock: SBIN 2699.00 as on Jul 04, 2014 15:30:36 IST I need a formula to extract the stock price...

I have tried many different ways to separate the house number from the street name: =(right) function with 'find' number text to columns replacing 'street' with 'address,' etc so I could separate by the ',' but there is so many variables. Does anybody have an easy way to separate the house...

I have a starnge problem with excell, when I open a csv file from my deveelopers it shows like a mess, but when they open the same file in their computer it shows the information arranged in collumns, the only way I can get it to look the same is to do the text to collumn move, the problem is...