text conversion

I am attempting to do a Text-to-Column conversion using VBA, and am getting a run-time 1004 (No data selected to parse) if the column is completely empty. This, of course, makes sense. However, how do I get past this? The source data used is formatted as text and the formatting is beyond my...

Hello, I'm creating a pivot table and would like to sort by the below text under Column Time In Queue. What I've been able to do so far is convert the days, hours, minutes, seconds into a "d.h:mm:ss" format but it looks messy and I'm not sure it's correct. <tbody> Time In Queue Invoice...

Hi, I receive a text version of a report from an external vendor that I'm looking for some help to automate conversion to Excel. When you try to import via the import wizard, because of the file format, never gets the column format correct. There are two reports as part of the file, the first...

I have a call log in which I enter the following information for every call: My Name, Date, Time of Call, Caller's ID number, Caller Site location(static). To expedite the data entry, I wrote a few formulas that autofill this information as soon as I enter the ID number. For example: Time of...

Hi, I need to extract the first location (ie London Luton) out of the below string. Ive been able to write functions for all the other using left/right and mid, but can get this one to work. 281653.P Smith 19-Jun-13 London Luton/Leeds I even used the Micorsoft help pags :) Split text among...

In cells D1, E1, and F1 I have the following dates: Jan-12, Feb-12, and Mar-12. In cells J2, K2, and L2 I have the following formulas: J2 ="Sales $ "&D1 K2 ="Sales $ "&E1 L2 ="Sales $ "&F1 The problem is that the result I'm getting in J2 is NOT "Sales $ Jan-12" but rather...

I need to create a forula that if the text in cell J is Butcher then text in Q = included (see below for the types.) I just cant seem to get it to work. Im using 2010. Any help please! I have 1300 fields to go throuh manually if not! <TABLE style="WIDTH: 200pt; BORDER-COLLAPSE: collapse"...

Good day I have a string of text that I am trying to split and make into multiple rows. The text isnt the same length and changes from cell to cell. An example of a couple rows of what I have is <TABLE style="WIDTH: 271pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0...