street

Hi I've been given a large amount of data to transfer from one system to another, the problem I have is that the original data is space delimitited, for example; 12 High Street Leeds Flat 1 28 New Street Openshaw Manchester P.O. Box 255 15 Low Street Hackney London Other than using text to...

Hi experts, I am trying to get some data from a webpage. My code is working fine on other sites but with this page i am getting run time error 91. Sample of html <h2>Impact Hub Honolulu</h2> <div class="col-xs-12 pade_none verified_date_rs"> <div class="verified_icon_rs"><img...

<colgroup><col style="mso-width-source:userset;mso-width-alt:15908;width:326pt" width="435"> </colgroup><tbody> Hi All, I am just a beginner in Excel If some can assist me in extracting Level #, Unit #, in the sample table below? it would be a great help for me DATA: Column A...

I have 2 columns Column 1 is the name of a street and that street name is repeated for each task that was completed on the street. I want to group the street name so that there is only 1 line but a new column for each task 10th street Repair pothole 10th street New Stop Sign 10th street...

I'm trying to figure out how to add rows to Range (I:O) if an certain number is present above it. Example if number 2 then add 1 row underneath it, if number 3 and 2 rows, ect, ect. This is a line of travel for driving and the numbers I am looking at is stops needed on that street. I have been...

I cannot understand why the total for the row labels is one in this example: <colgroup><col><col></colgroup><tbody> Row Labels Sum of Churches Ahoskie 1 Aulander Baptist Church 1 Beulah baptist Church 1 Cashie Baptist Church 1 Center Grove Baptist Church 1 Cool Spring Baptist...

Hi Could someone advise on how you can export each column to an individual csc or tab file using the header as the file name please. i.e. <tbody> Street 1 Street 2 Street 3 1 1C 1 MOORGROVE HOUSE 2 3 2 MOORGROVE HOUSE 3 5 3 MOORGROVE HOUSE 4 7 4 MOORGROVE HOUSE 5...

Hi Someone's help would be very appreciated. I have a list of addresses where there are multiple street names and all of them have a different house number in the cell to the left of street name. I would like all of the house numbers to come under the street name. I have removed duplicates...

I have a macro (below) used to clean up a file of addresses. One of my clean steps is to flag any addresses which contain number ranges (i.e. a dash "-"). It was working fine but now that I have a larger file with 10k+ addresses I think I need to adjust to make it less restrictive. Here are a...

Hi So I have been trying to work out a problem I have cells that have address in them and we have another tool for geocoding, so we need these addresses to be in a standard format So I want to basically conditional format to turn the cell red or something if the cell data is not entered...

Hey Mr. Excels,:cool: I am currently running a project that requires an automation on data. I have altogether 78 sheets: - 3 sheets are output data. - these 3 sheets are differentiated by payment types. - the rest of the 75 sheets are category sheets - category is located in J column in...

Hi. I have created a table (job list) that contains jobs that are assigned to different workers on certain dates. I want to be able to extract a list that I can print off that will act as a daily job sheet. eg date : 10/06/2018. Worker: John Doe job 1 123 nowhere street. U.K...

Hi Thank you in Advance, I have a column of Address, and i would like to know the Number of times, a comma occurs in the cell. <tbody> Zillmere, QLD, 4304 Westfield Belconnen, Benjamin Way, Belconnen, ACT, 2617 Wanneroo Central Shopping Centre, Rocca Way, Wanneroo, WA, 6065 Unit 6...

Hi all! I need to create mailing labels with a list of data I've received. My lines have one, two, or three names. I tried to Convert Text to Columns, but there are just spaces separating the text. Here's an example from my list: Paul & Joan & Marjorie Roderick 75 E. Charles Street Long...

Im trying to get these tasks accomplished in excel but I think I am asking to much of a macro. I know some of these things are easy but others are kicking my butt. But im sure someone out there knows better then me about it. I tried to explain it as well as I could but feel free to ask any...

Hello!! Is there a way to check if two commas exist in a cell? In cell H3 of my worksheet users will enter an address and I want to make sure they use two commas when entering an address as another sheet takes this address and splits it. for example: 123 ABC st Moraga CA 97501 should read...

Hey Everyone! I need to create a macro to make come reports easier to handle. One of them looks like this when it gets put into excel. Basically it tells who the owners are to certain stocks. I need only the rows where it tells the stock owners only. A cell like that looks like this for...

Hi All, Thank you in advance, I have a of sheet organizations and designations - NEW sheet In this sheet some of the organizations may have only one designation or Combo of more than one for a given organization I have another Sheet named Old - which contains information with designation...

Evening all, could someone help/point me in the right direction please?I have an excel workbook with approx. 30 spreadsheets on. 1 tab contains monthly costings and the second tab is a to Spreadsheet 2 (costings) <tbody> Development address Month (this column has every month for the year and I...

Hi All I have in Sheet1 Column A the data for about 3000 contacts which I want to split into individual contacts on sheet 2 going accross the columns. The problem is that some of the contacts use 4 rows, others 5 and some 6. This is causing me all sorts of problems. The only saving grace that...