Thu 13 Dec 2007, 17:14Delegate Gemma said...
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?
Fri 14 Dec 2007, 11:49Delegate Paul said...
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
