Reformat Data File

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.

Split Addresses:

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:





Test Road




would become

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

would become

Telephone 1 Telephone 2 Telephone 3


01914241111 07961931111

01308451111 07525061111

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?

Habilidades: .NET, Processamento de dados, Excel

Veja mais: reformat data, how much does it cost to have someone write a script for you, file expect, expect file, excel split columns, excel split a cell, separate data in spreadsheet cell, split file, script process excel files, move data excel, return file, write test script, excel split, cost file, write file excel, excel split cell, data mobile numbers, write multiple excel file, data processing excel test, cell phone cases, excel reformat data, 1111, excel data process, zip code test cases, Nottingham

Acerca do Empregador:
( 0 comentários ) United Kingdom

ID do Projeto: #5107030

88 freelancers are bidding on average £103 for this job


Please check my reviews for my expertise area and buyers saying about my work, if you check my reviews then you see, i've no incomplete project and no bad wording for my work please check my profile here http://www.f Mais

£166 GBP em 1 dia
(284 Comentários)

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

£50 GBP em 1 dia
(167 Comentários)

Hi, We are very good at this type of work. 100% quality and accuracy guaranteed. we can do it by using excel complex formula's. Hope you would consider our bid as we have enough experience and great client reviews. Mais

£210 GBP in 5 dias
(185 Comentários)

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.

£200 GBP in 3 dias
(215 Comentários)

Hi, If you can provide me original CSV File then i will analysis it and give you feedback. thanks Kalpesh

£100 GBP in 3 dias
(48 Comentários)

I have gone through the complete details. I will provide the solution within 24 hours. I will write the script. Please just clarify a single point 1-move the postal/zip code to the last address line column ? Mais

£40 GBP in 0 dias
(114 Comentários)

Lets Start. Having a team of Professionals. We provide high quality work with accuracy. Would you like to discuss more about your current project?

£50 GBP em 1 dia
(221 Comentários)

Hi there, I can do this one and also provide an automated tool for the same so that in future you can use it your self to save both the time & the money...Let me know what you think It would take hardly 2-3 hours to Mais

£44 GBP in 0 dias
(45 Comentários)

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

£33 GBP in 3 dias
(25 Comentários)

Hello Sir, Thank you for this wonderful opportunity. I am writing in response to your advertisement for a “Reformat Data File Share”. After carefully reviewing the experience requirements of the job description, Mais

£111 GBP in 3 dias
(106 Comentários)

Good afternoon, I've got free time this week on to take on a small project, and this one looks easy enough. A nice change of pace from my current workload! I have a lot of experience with un-formatted data parsin Mais

£122 GBP in 2 dias
(9 Comentários)

Hello, I'm an expert in projects like yours. I'm going to write Perl scripts to reformat your data. Finally, I will manually check the result to make sure it's correct. The price and time are £80 and 2 days, respect Mais

£80 GBP in 2 dias
(54 Comentários)

Sir, I am well versed in this kind of jobs and can do your project as per requirement. Refer my online work portfolio at [url removed, login to view] Looking for further discussions in this matter. with than Mais

£147 GBP in 3 dias
(51 Comentários)

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.

£38 GBP em 1 dia
(46 Comentários)

Hi Its a easy work for me I have the code do solve that issue of your please send me the file and also I have already done similar kind of work on a same situation on a file in which the client wanted it to assembl Mais

£100 GBP in 2 dias
(73 Comentários)

Hello! I'm very interested in this project and I'm sure I can help you:) One question...each address have 5 lines? Please check my portfolio:) Your project will be formated using powershell script:) [url removed, login to view] Mais

£70 GBP em 1 dia
(43 Comentários)

Worked on automation tasks for data related projects. I know macro well along with Excel files. you can check my previous projects.

£55 GBP in 2 dias
(8 Comentários)

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.

£38 GBP in 0 dias
(65 Comentários)

Hi, I have experience in job like this and i can do this job very fast, please contact me for details

£150 GBP em 1 dia
(52 Comentários)

I can do it.................................................................................................................................................

£30 GBP in 3 dias
(25 Comentários)