street

  1. A

    Splitting Address Out With Spaces

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

    Need some help in parsing HTML

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

    Extract and Remove Level #, Unit #, in address Address

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

    Convert 2nd column values to rows when column 1 is the same name

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

    Adding rows with certain values in cell.

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

    Sum in a Pivot Table

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

    Export colums as individual csv files

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

    Move cells into catergories

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

    Macro Flag Records with Dash Alpha/Numeric

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

    Checking that a cell has an address in it

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

    VBA - transfer specific data within a sheet to specific sheet by unique identifier

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

    Data output

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

    Count Occurrence of a Specific Character in a cell

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

    Need to Separate Names and Addresses

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

    Is this asking too much of a macro

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

    Check if 2 commas exist

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

    How should I tell the difference?

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

    Find Missing Information

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

    Excel

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

    copy data to different columns

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

Some videos you may like

This Week's Hot Topics

Top