street

  1. G

    Extract text before, between and after a character

    I cannot figure out how to extract this from all the other examples I find here. (Great site, thanks everyone!) Text A1: Bob Smith ~ 123 Main Street ~ Houston ~ Texas ~ 77001 I need: B1: Bob Smith C1: 123 Main Street D1: Houston E1: Texas F1: 77001 Thank you!
  2. L

    Conditionally Email (Outlook) Row on Change

    Hi all: I have the code to email through Outlook but I need to change it up a bit. I have 600+ Rows of data. If someone enters "Y" in the T Column, a Macro should open Outlook and include in the body only the Row of Data that the "Y" was just entered into (On Change). The EmailAddr will be...
  3. T

    VBA Translate Column Data into Rows

    I have a column of information and would like to find a way to translate it into rows using VBA. Every 3-7 rows in my existing column has a cell "New Record". I'd like the information below that cell to be laid out in a new row. Currently: <tbody> New Record 4756 John Doe 123 Street...
  4. M

    Calculating how many times a random word appears in a cell

    Hi! I have a list with 600 streets in one column and there zon in an other column. I have a cell that randomly picks a street and its zon and i first look at the street and guess and then lock for the answer in the next column. In a third column I like to count how many time each street has been...
  5. E

    Concatenate Strings - merge values IF...

    Hi guys! Happy New Year! I have a little problem. I have 2 columns with adresses and cities. Almost always there is a street number with street name in column H and City in column J. But not always. Sometimes a little village do not have street names, just numbers and I need to merge that...
  6. B

    Split String at occurrence of Uppercase

    Hi I have a column of address - with the City in Upper case, I would like to split the string at the occurrence of Uppercase from right Example - Uppercase i have highlighted as Red here <tbody> Unit 12, Wellington Fair 40 Lord Street (Entrance off Wellington Street) EAST PERTH Building...
  7. B

    Separate Street Number from Street Name

    Hi, Thank you for taking a moment to read this - I would like to separate the street number from the street name Criteria for Separation - From LEFT, Separate at NUMBER Example <tbody> <tbody> Wentworth Ave </tbody> <tbody> Vil18 1 Monty Pl </tbody> <tbody> Unt17/23/ Chave St...
  8. S

    Excel formula will true if have same word in other column

    Hi all, Please help me to fix this I have a problem. I want to put a formula in Column B which is "True" If Column A have same word in Column E within the column. Sample <tbody> Column A Column B Fc Hoechst True Al Hidd False Dinamo Minsk True The Balloon Place True 100 Ball...
  9. muhammad susanto

    Extract Text Only Before String "No."

    hi all.. how to extract data/text only before string "No." this my layout : Excel 2007 32 bit EF 2dataexpected result 3 Street Sudirman No. 233 Sumahilang Pekanbaru Street Sudirman 4 Street Kandis Gg Antara No. 10 Pekanbaru Street Kandis Gg Antara 5 Street KH. Ahmad Dahlan No. 2C...
  10. M

    Find word in list

    i have two columns. If a word or words in the world list is found in the text string in column A, I want to put found in the adjacent cell or not found. I want to be able to drag cursor down column C. <colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>#DAE7F5[/URL] "] A B...
  11. B

    Data scrubbing a list of street addresses - how to trim off street number?

    Hi all, Hoping to find some help on this one! I have a list of thousands of addresses containing numbers and street names, and I'm trying to "shave off" the number (and sometimes, unit name - e.g. 15/A or 64C) from this list in order to isolate the street name. Unfortunately there are no clear...
  12. L

    separate text

    Hi I have a column which has text like following 123 main street CityName StateName 123456 I want to put street number, name, cityname, statename, postal code all in different columns. I know it is possible to use Text-to-Column but I was thinking about using functions/formulas in case the...
  13. J

    Search combo box

    Hello, I have a combo box in a form so street names are the same format (Avenue, but not Ave or Road but not Rd). A user will type a home address, then choose the street from the combo box. I'm wondering now if I can put my cursor in the combo box field and search for a specific street. For...
  14. B

    Delete Duplicate Between Two Columns - Criteria from Right

    Hello - Please help me delete Data between Columns I have two Columns of Data I wanna delete the Data (repetitive between Columns) To Note - the term may occur mutliple times in address as in Example Number 4, 7 - Search from Right and delete Common data occurring first from right <tbody>...
  15. H

    Address Standardization Question

    I'm trying to take a list of addresses and standardize them using a macro. Basically it's a bunch of replace commands at this point, but I'm having trouble with street names that contain the words I'm trying to abbreviate. For example, I'm abbreviating East as E, but there are streets named...
  16. K

    Lookup in Row, match data in cells of that row and return Column header

    Hi All, I am facing a peculiar problem. I want to lookup for a text string in the rows, match a particular number in the values of that row, and then return the column header to which it matches. Below is a sample data: <tbody> Address ABC DEF GHI JHL MNO Ayala Alabang Village, Muntinlupa...
  17. B

    Extract data into separate cells

    Hello. I have data in a cell that I need to extract into seperate cells. Here's the example: 14 = Street RCA Combo #203: Task BG0178 15 = Street RCA Combo #204: Task BG0018 16 = Street RCA Combo #205: Task BG0020 17 = Street RCA Combo #206: Task BG0022 18 = Street RCA Combo #207: Task BG0348...

Some videos you may like

This Week's Hot Topics

Top