Julie has attended:
No courses
Splitting cells
I have an cell with the full address of a property in it, what formula do you use to split it up so that the first column has the first line of the address and the second line in the next column etc
RE: Splitting cells
Hello Julie,
Thank you for your question regarding splitting cells.
Please send me a file with a few of the addresses you require to split up and I will create a formula to separate the data into several columns.
Attach the file to an email and send it to me at:
rl@stl-training.co.uk
I look forward to helping you out with this and await your reply.
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer