one column

I need help on how to take one column with an address and make it into multiple columns without using the Text to Columns method. My example address looks like this: <tbody> 2000 STREET ADDRESS DR CITY, STATE 20000 </tbody> After I copy and paste that into a multiple column cell, I would...

Hi all, I've been searching for an answer to this for some time now and I'm sure there is probably a simple solution. I have a large table in which some cells have text and the rest are blank. On a separate sheet I would like to have a list to include the text from the cells and disregard the...

Hi, I have an excel file in which in one single column multiple change events are happening. For example on the basis of change in value in cell B9 some code needs to be run and then the basis of value in B10 some code needs to be run but I am not able to keep this 2 events separately. Can you...

I have difficulties in date and time format. Since I always need to change the day/month/year. Usually I just did it manually, however after I found this amazing macro things, I hope I can do it using macro which can save me a lot of time. Here the situation is: I have 16 years (1996-2011)...

I am trying to copy sections of one column to multiple columns. For example, how can I copy the PROFIT data (for AAEQX) from Column K into Column P, but then copy ACWIX into Column Q, and so on (I have 226 of these to do)? In the example, for the first couple columns, I simply used '=' and the...

I am using Microsoft Office Excel 2007 and Windows 7. I have a lot of data (1-4 thousands of rows) where each column represents a year for 15 years. Every set of 5 rows are different data for a company and the values for every year of each data are under the representative column. I want to...

Good afternoon - could I get some help on being able to move all the data in Column "I" (eye) across all tabs (with the exception of the tab named "Summary") into one column of the "summary" tab? Currently I have a script running which collects all the data in each tab and it copies it to the...

I need to count the number of instances when the term "Three cameras" or "Four cameras" shows up and when the term "Standard camera" shows up 3 rows prior and multiply the respective array "3 or 4" to get a final standard camera count. The data structure can not change An example would be...

I am working with csv files from different programs and after my old computer broke down and I got a new computer and installed excel again. (excel 2007 on both computers) On the new computer when I open the csv files, they open with all the information in only the first column. Well, one csv...

i have this three columns: <table style="border-collapse: collapse; width: 162pt;" border="0" cellpadding="0" cellspacing="0" width="216"><col style="width: 54pt;" span="3" width="72"> <tbody><tr style="height: 11.25pt;" height="15"> <td class="xl64" style="height: 11.25pt; width: 54pt;"...