postcode

Hello all 1st post on the forums but have been a long-time browser :) I am wondering if anybody can help point me to some good MapPoint resources or can help me with some code. I think what I am trying to do is quite simple but struggling to get started. In Excel, I will have a list of...

Hi All I hope there is an easy way of doing this as I have 30,000 cells I need to extract some information from. In a cell I have some information extracted from an invoice. For example BG12CF942RU, BG15CF96EFDI the information isnt consistent except for one part. Somewhere in the cells will...

Hello, I have data in Column A to B. Column A="Unit Number" , Column B = "Delivery Name" and Column C = "Postcode". The Issue I have, the titles of each of the columns are in the data set. <tbody> Unit Number Delivery Name Postcode 2234we Home JK34 4FG <tbody>...

Hi I'm a new member here, nice to meet all of you :) I am trying to create a VLookup function which will give an area by using a postcode (UK). I have followed directions on another website by searching 'determining a state from an area code' but I am getting a #VALUE ! error when using their...

I’m hoping someone will have the patience and be kind enough to help me with a small VBA Select Case issue I’m having. I have a spreadsheet where I will be asking the user to enter their (UK) address including their Postcode / Zip code. I want to use a Case Statement to check and validate...

Hello, Apologises if this this has been asked before - I have seen a few similar thread but nothing that specifically helps with my problem. I am quite an advanced Excel user but my knowledge of array formulas is poor, something I would like to work on. Problem: I have a large dataset of...

I have a list of 800ish unique establishment references and I need to enter each one into a search box on a website to get a specific item of information form the result. I can see there are quite a few solutions out there but I need to get this done ASAP and as I need to work on other areas of...

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

Hi I have two unrelated tables. postcodes is a complete list of UK postcodes and sf is a table of opportunity names. I have been using the formula below to search for a postcode within the column [opportunity name] in the sf table and return Yes/No. Postcode = IF( SUMX(postcodes...

Hi, I'm a newby to the site so first of all would like to say thanks for letting me join:) My question (which may seem rather basic) is that I have 2 worksheets taken from different workbooks. The first one contains information for interested customers, ie. company name, contact, type of...

Hello This should be easy but I can't seem to find how to do it. What I want to do is create a worksheet template so that when a list of addresses are pasted into it, all the Scottish postcodes will be highlighted. The postcode is already seperated from the address into its own column (K)...

Hi, i am new to the forum and was looking for some help. i have recently been asked to produce MI for a new business unit but all my excel skills are self taught and i have no idea where to even begin. I am limited by the work systems so i cannot export the data to work from my own laptop and i...

Hi, I have what I think is quite a simple issue, but it's baffled me! I have a list of postcodes and I need to add a space in the middle in order to use it with another data source which are already formatted this way. I currently have postcodes such as 'PR88AG' and I need to add a space...

Hello all! I have a list of dentists (column A) with the streetname (column B) but I don't have the postcode, does anybody know how to get the postcode in column C without copy + Paste every single dentist in google? Many thankss

Hi, Background: I have a list of shipping prices that depend on; Country; Postcode; Weight. Many postcodes have the same price but are not in number sequence, for example postcodes 5000-7999 will be the same cost as postcodes 11000-12999. Our website CMS system, Magento, requires all shipping...

I have tried many different ways to separate the house number from the street name: =(right) function with 'find' number text to columns replacing 'street' with 'address,' etc so I could separate by the ',' but there is so many variables. Does anybody have an easy way to separate the house...

I've attached an example workbook. I have a list of suppliers and postcodes and would like to insert a duplicate row with each trade that a supplier does in that postcode. So i need a macro that takes the trades on one sheet then inserts the number of trades that supplier does, duplicates the...

Hi there - I hope someone can help. I have a very limited knowledge of VB with an intermediate knowledge of formulas and am using Excel 2011 for Mac. I wish to create a spreadsheet that will enable me to lookup which electricity distribution network companies operate in specific regions in the...

Hi all, I am having a stupid day... and can't see why this isn't working... Simply... why isnt this TRIM() trimming please? Private Sub CommandButton1_Click() Dim sapFARM As String sapFARM =...

Hi I need a copy of the above in excel/csv so i can perform some lookups and monitor where our customers are coming from. Does anyone know where i can obtain this? Many Thanks