98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Splitting cells
Splitting cells
Resolved · Low Priority · Version 2010
Thu 16 May 2013, 16:07Delegate Julie said...
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
Thu 16 May 2013, 19:29Trainer Rodney said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Quick Absolute Cell ReferencesWhen entering cell references in a formula you probably click the cell, or you may type in the cell reference. If you require any of the 4 variations, press the F4 key now before you press Enter to toggle around the relative and absolute entries ($signs). |
