addresses

<tbody> Hello everyone can you please help me in my problem, how can i Compare two lists Containing each email addresses and Delete the matched Emails addresses from the first list, the main list is L1 and the second list in L2 which contains...

Hello I am not a very experienced person with Excel and advance functions so I need help with this 3 problems that keep spending infinite time and nerves. :banghead: 1. I have 20 opened tabs in my browser and I want to paste all the 20 URLs to a certain Excel column and selected 15-20 rows in...

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

I have two tables. Table 1has Electric Company addresses and table 2 home addresses. I am trying to link the power company meters to the correct home addresses but the home address are some what different. How can I link the meters like the diagram below? Is there a formula I can use that will...

Could someone please help me. I have been trying to solve this for ages and I am sure it is something very stupid, but I cannot see what is wrong. this code is part of a much large macro. The active workbook is dn (i should not really need to activate it as the rest of the sheet is populating...

I am writing a macro to do some highlighting. The main macro calls several Subs to do some of the work. It needs to pass a list of cell addresses to these subs. I am wondering about the best way to do that. My current solution is to pass them as separate arguments: Sub Highlight() . . . '...

Hello All, This is my first of likely many questions on this forum, as my excel skills are far too basic for my liking and I am keen to better them. I am given a task where I have a row of various different addresses for head offices of public companies. I just need the US state of where they...

I have MS Word and Excel for Android on my new Android tablet (Samsung) I'm a musician who wants to use it on stage. On a Win PC I worked out an elegant little spreadsheet that allows me to see my set lists and punch up the charts for it with a tap using a hyperlink to a docx file. No...

Hi I have a list of addresses that currently sort as follows: 1 Acacia Road 10 Acacia Road 11 Acacia Road 2 Acacia Road 21 Acacia Road 22 Acacia Road 3 Acacia Road 31 Acacia Road etc. How can I get them to sort in ascending order of the number i.e. 1, 2, 3, 10, 11, 21, 22, 31 etc I have...

I have a membership list of addresses, column "P" contains the amount paid, "R" contains "EMAIL" or "POST" choice, (as text), and "S" contains the date of entry (automatically generated on entry of amount paid). A letter is sent out after payment to say if they will receive the newsletters by...

Have a quick question. Need to change some information in a column list of email addresses that are hyperlinked to outlook. Most addresses are correct with a hyperlink that works well. I have a couple of addresses that have information in the cell that opens up an outlook message to a...

In column M is a sequential list of column addresses that I need to add to. Is there a way to use a function so that the next column address in the sequence appears automatically rather than my having to type it in? O P ... rather than typing in "P", it would be the column value above "plus...

I have 2 columns of addresses and I need to determine which addresses are not present in the second column. The issue is the text values are not the same between the 2 columns. EX: Column A has 1 SUNFLOWER. Column B has 1 SUNFLOWER LN. Any formula to attempt to identify the address that are...

Good day This is my first post. Please assist me in finding the appropriate programming (VBA) or array formula to generate a list of addresses for cells in an array with FALSE values in them. I have a sheet comparing values on a similar sheet and a third sheet with TRUE and FALSE values to...

I have an incomplete address list with lost of blank cells under either postcodes, regions or cities. If I input a list of UK Postcodes, Regions and City into a separate sheet within the same workbook how can I use excel to fill the blank cells within a separate worksheet within the same...

Hello, I am using Excel 2016 on a Mac. When I used to have a Windows months ago, when I removed duplicates in a column, the rows would move with them which kept all the information together. Now, when i go to remove the duplicates, the rows stay and the column shifts which makes the information...

I don't think this is an Excel question, but I've visited Mr. Excel many times over the years and figure someone here might have an answer. My mom wants to collect her 16 grandchildren's contact information in a place where it can be always updated, as opposed to the notebook she now uses...

Hi guys.. I'm needing to create a hyperlink for email addresses which is usually no problem however this time I just have too many. They are all going to the same domain aaa.gov.uk so would that help at all? I have 15 addresses in total which is just couple too many considering they are quite...

Hello, For some reason the spaces between numbers and words have disappeared in the addresses in my excel spreadsheet. Can someone please help? Here is a sample of the data: "Unit4,313DorsetRoad" "Unit4,149MountDandenongRd" 1WavellAvenue 1WavellAvenue 1WavellAvenue 61UnderwoodRoad...

Hello, I have a large number of addresses which have been put into one column. I need to split up the addresses in order to put together a mail merge file. The problem is that there are too many individual words for the normal text to columns function to work eg one address might be c/o Mrs M...