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 » excel training program - Excel
excel training program - Excel
Resolved · Low Priority · Version Standard
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
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:Repeat actionThe F4 key will usually repeat your last action. e.g. delete a row, then select another row and press F4 to delete again. |
