excel training program - excel

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training program - Excel

excel training program - Excel

resolvedResolved · Low Priority · Version Standard

Gemma has attended:
Excel Intermediate course
Excel Advanced course

Excel

How do you split a cell with information already existing in it, into 2? Can this be done?

RE: Excel

yes it can be done.

you need to use the left and right functions

=left(A1,5) displays the first 5 characters of cell A1

=right(A1,5) displays the last 5 characters of cell A1

change the cell reference and the number 5 to whatever you need it to be.

Paul


Server loaded in 0.1 secs.