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.
Any questions please ask.
29 freelancers are bidding on average $23 for this job
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 !