Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

splitting cells

ResolvedVersion 2010

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

Excel tip:

Hiding and unhiding columns using the keyboard

CTRL + 0 hides your columns and CTRL + SHIFT + ) unhides them although you would need to highlight the column letters either side as per normal

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.