I have a spreadsheet containing UK data with 2 columns (addresses and telephone numbers) but each of these columns has the full address and multiple phone numbers per cell.
I would like them split out into their own cells as detailed below.
I want to keep the original columns intact with the new columns inserted to the right, please.
The address lines are all contained in one cell with a return char at the end of each line.
I would like the address lines split out into their own cells for example:
Address Line 1 Address Line 2 Address Line 3 Address Line 4 Address Line 5
1 Test Road NOTTINGHAM Nottinghamshire NG1 6AA
please note that not all addresses are contain 5 lines some more, some less.. Also would you be able to move the postal/zip code to the last address line column.
Split Telephone Numbers:
I would also like the telephone numbers split out into separate cells. The telephone column does contain letters and in some cases spaces within the actual telephone numbers.
UK Telephone numbers are 11 digits long if that helps so...
0191 424 1111 NA 07961 931111
01308451111 use mobile 07525061111
01543 483 111 01543 268 111 07968 345 111
Telephone 1 Telephone 2 Telephone 3
01543483111 01543268111 07968345111
I have two files, one with 5000 records and another with 2000.
Ideally what I would like is for someone to write a script to run these files through to split out the addresses and telephone numbers, I do not expect someone to sit there and go through 7000 records manually. Could you please let me know how long this would take to write/process and how much it would cost?
88 freelancers are bidding on average £103 for this job
Hi, Shall provide you with Excel macro file which will take the input file and generate the desired output formatted file automatically. Please confirm and I can start working on it. Regards, Arul
hi, Ready to start your project work. Highly interested. Expert in data entry and excel. I will complete with 3 days. Eagerly awaiting for your positive reply. Thanks, Jennifer.
Hi there, The requirement is strageforward. This is a easy issue. I will make an application app and input 2 files and then export to exel with format you want. Let me do it. Many thanks
Hi there. I am senior developer from Vietnam. I have been working on this site for 2 years. I am interested in your [url removed, login to view] let's me help you.
Hi! I understand what needs to be done and can do it right away. I will write a VBA macro to fully automate the process. I have over 12 years of Excel and VBA experience.
I can do it.................................................................................................................................................