Em Andamento

Move block of text/numbers new lines

I have pages of text /numbers in the following format:

name surname address 08 1111 3333 name surname address 0498 1234 1234 name surname address 08 1111 3333 name surname address 0498 1234 1234 name surname address 08 1111 3333 name surname address 0498 1234 1234

-numbers are all different

-text is all different

I simply want a way to move each name address number to a new line so I can then sort it in excel.

The logic would be something like "if 4 numbers in a row then move the next letter to a new line". If that operated on it all then each name address number would be on its own line.

I don't know if it's possible in excel.

Maybe there is already a website out that can do the above.

If you are going to bid, please make sure you already know how to solve the above or know where I can just plug in my data and do it ( if there is already a website that can do it).

Please do not bid if you haven't worked out how to do it.

The solution needs to be something I can do myself, ie a specific description I how to do it in say excel or some other program that is cheap/accessible.

Thank you.

Any questions please ask.

Habilidades: Excel, Word

Ver mais: thank you letter format, excel cheap, my next move, move data excel, text row, please block, block text, program sort text, program sort lines text, excel address text, program sort numbers, format numbers, next row excel, block program

Acerca do Empregador:
( 1 comentário ) Glen Iris, Australia

ID do Projeto: #6826258

Premiar a:

paris2785

Hi there - My name is Paris. I've read your brief and can see that your task can be achieved with a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would appr Mais

$30 AUD em 6 dias
(26 Avaliações)
4.2

29 freelancers estão ofertando em média $23 para este trabalho

Teloquence

Hello, I am top freelancer on this forum with 200+ five star reviews and with a completion rate of 90%. I have understood your requirement and I am sure I can implement this. Check my past reviews for your reference. E Mais

$24 AUD in 0 dias
(238 Comentários)
7.0
avinav606lx

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality ou Mais

$30 AUD in 0 dias
(80 Comentários)
5.9
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I will do this excel. I have completed more than 220 projects. Please look at the feedback left by my employers to know more about my work. Wai Mais

$30 AUD em 1 dia
(45 Comentários)
5.5
expertatwork

hey there, this can be done using a simple macro (you can understand that easily)... should be a few lines of code... this will be done within excel...please reply, thank you !

$25 AUD em 1 dia
(77 Comentários)
5.1
dragos1910d

Hi, I am an excel expert, I can create o formula for you today. Contact me. Kind regards, Dragos !

$19 AUD in 0 dias
(49 Comentários)
5.0
parsermonster

Hi! I just worked out a simple [url removed, login to view] involves regular expressions, which you can use by making a reference in Excel. For the bid price, I will give you the Regular Expression and you can work out how to ap Mais

$25 AUD em 1 dia
(13 Comentários)
4.8
Midlander

What you describe is straightforward, with the only question being which programme you have used to hold the data at the moment?. Assuming it is any form of text file, I will import your existing data into Excel as Mais

$35 AUD in 2 dias
(9 Comentários)
4.1
khushh07

Hi I have seen your job post and understood your requirement . As an expert in web search and data analysis, I can do the job you posted within given time frame with maximum accuracy, and looking forward to work wit Mais

$30 AUD em 1 dia
(8 Comentários)
4.0
denisaelena

Propunerea nu a fost încă furnizată

$25 AUD in 0 dias
(14 Comentários)
3.5
MKL7

Dear, Please contact me and I will give you a screenshot of a similar project I have completed this week. This is the project: [url removed, login to view] Please have Mais

$15 AUD in 3 dias
(16 Comentários)
3.1
macroPOL

Hello, I can do it. An example of how I can do this project you can see on YouToube: [url removed, login to view] Thank you very much Jan Krzyzak

$30 AUD in 3 dias
(3 Comentários)
1.6
berincg

Can be done in 24 hrs after assignment confirmation if on a weekend else max 36 hrs. Step1: Get all data in an Excel Step2: Delimit data by space using a macro (may need some more logic if address have space) Step3: Mais

$15 AUD em 1 dia
(1 Comentário)
0.8
kajteksolutions

Hello, I can develop an easy to use program for you to do this task. Here's a suggested process: - Locate input file - Click Start button - Program will read input file, convert data, and save output to Excel s Mais

$30 AUD em 1 dia
(1 Comentário)
0.8
satori12345

Experience: I am a Dallas based Financial Analyst with over 20 year experience in Excel and Visual Basic programming. I have created a significant number of automated Excel forms with buttons and macros that perform a Mais

$10 AUD in 0 dias
(1 Comentário)
0.4
umbrellasofts

A proposal has not yet been provided

$10 AUD em 1 dia
(1 Comentário)
0.0
androidrama001

A proposal has not yet been provided

$20 AUD em 1 dia
(0 Comentários)
0.0
AHTOAH

Hello, I'm a vb.net programmer and can build an application to separate each "name surname address 08 1111 3333" to new line. I have tested it and it works. Let me know if you are interested and I can build that c Mais

$13 AUD em 1 dia
(0 Comentários)
0.0
borosede

Még nem kapott javaslatot

$25 AUD in 3 dias
(0 Comentários)
0.0
ayanendudreamzz

I am expert in data extraction from text to xls SPSS and STATA. I will be helpful to you. I can finish this work in two hours.

$10 AUD in 0 dias
(0 Comentários)
0.0
shuvo2alam

Thank you for this wonderful opportunity. Today Your job posting has caught my attention because Iâ??m keenly considering your job post including these skills. I have excellent experience in Microsoft Office and Admin Mais

$15 AUD em 1 dia
(0 Comentários)
0.0