addresses

I have a list of addresses in Excel that include the county of each person. I would like to do a mailing for two of the counties only. How do I separate these addresses out?

Greetings everyone, Can someone please help me with the following: I have a long list of e-mail addresses in Excel that I want to send emails to. I want to send the emails individually so that I can track who/when the emails are opened. I want to use Outlook, because I have made templates of the...

I am trying to make a vlookup that can return all email addresses associated with specific internal and external ids. I want to be able to type in the Internal ID and return all email addresses associated with it. IE type in 4 and be given the value in cell F7. I believe its going to involve an...

Hi, I have a list of email addresses in a spreadsheet. I have another sheet in the same excel with a Pivot that allows me to filter based on city. For example if I filter the city by "Amsterdam" I can see all the email addresses in "Amsterdam". In the main spreadsheet with all the email...

Hello, I have a bunch of addresses where I need to extract state name to a new cell. The addresses look the following way: <colgroup><col></colgroup><tbody> 843 E Main Ste 203, Medford, Oregon 97504-7137 </tbody> <colgroup><col></colgroup><tbody> 7648 Victory Blvd, Newport, Arkansas 72112...

Hi! I am trying to use the Vlookup formula but receiving an #N/A. The table array consists of addresses and I am attempting to match those addresses to the master file/column addresses to determine if those addresses are equal and match. In the array table of addresses, their are no suits...

I have thousands of rows with email addresses in column A. Problem is they are amongst other text at the beginning, middle or end. Can a code be made please to extract the email addresses in to column B next to it? I haven't posted an example as for security and its pretty self explanatory...

I have data on rental prices for houses in the city of Mumbai. It contains approximately 12000 addresses, their coordinates, area, rental price and number of rooms. In a separate file, I have 1000 addresses with a lot more variables (but they also have the coordinates, area, rental price and...

Hi, so Row A contains lots of different but unique individual e-mail addresses, thousands in fact in the format : Alan.Smith@MrExcel.com Karen.Jones@MrExcel.com Clive.Bloggs@Microsoft.com Brenda.Forbes@MrExcel.com what I need to do is count the instances that an e-mail Domain Name appears so...

I've got a data dump from a freight carrier that has columns for ship to /receipt to addresses. The issue I have is that 1 address can be listed multiple ways. For example, 123 East, 123 East St, 123 East Street. I have a list of the proper addresses. How can I go about populating the...

Quick backstory that helps explain what I'm trying to figure out how to do. Every week I download a report for my work that has the following info: | Client ID | Client Name | Client Address | My boss is wanting to add an additional column to the report that pulls the country out of the...

is there a formula I can use to change the formats of addresses I pulled down in a data dump? I have a ton of addresses that show up like this in Excel: "20 LONESOME DR " I need them to look normal like this: 20 LONESOME DR even with doing a find/replace for the parentheses it...

Hi all, been some time since I have had need of your excellent advice/help. I need to send out a questionare to approximately 50 people. Each one will contain their individual personal information that I need to get back from them if it needs to be updated. I would like the excel spreadsheet to...

Hey, First time posting. I have a data set with duplicate account keys and values in the form of email addresses. I need to create a consolidated data set that has only one account key and a corresponding email value. My issue is this -- some of the duplicate account keys have blanks or "old...

Hello - I have a spreadsheet of URLs, some of which contain IP addresses and some don't. I'm struggling to write an excel formula that will identify the URLs with IP addresses in them, and extract that IP address into another cell. What formula would I paste down column B to achieve this...

I have a list of IP addresses that I need to import additional information into a new web solution. We pretty much used access to keep track of all the assigned IPs on our network. We have a access file with over 300+ tables for all of our network addresses. The problem here we are very...

Board, I tried to search function, but it keep telling me there wasn't any results so I am posting here for help. I have two sheets, each has a list of mailing addresses (first name - column A, last night - column B, address - column C, city - column D, state - column E, and zip - column F). I...

Hi long time lurker 1st time poster. I would like to send an outlook email to a list of email addresses in column A (first email address starts in cell a2). Each email should have 100 addresses in the "to", then another email creates with the next 100 addresses. Emails should create until until...

So I am trying to merge outdated data with updated addresses. Some of the names are the same, some of the addresses are the same, but some are new and need to be replaced. Left side is old, Right side is new. There are THOUSANDS of entries. What do you think would be the most practical way...

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