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 text using functions
Splitting text using functions
Resolved · Medium Priority · Version 2007
Mon 26 Mar 2012, 16:24Delegate Anuja said...
Anuja has attended:
Excel Intermediate course
Excel Advanced course
Excel Advanced - Formulas & Functions course
Splitting text using functions
What is the best way to split text from a sentence, using search, len, mid, right and left functions in the simplest way?
Tue 27 Mar 2012, 10:08Trainer Paul said...
RE: Splitting text using functions
Hi, there are a number of combinations you could use here. The easist way is to use your left or right functions. The problem with this is that you wont get the desired result when autofilling.
Another option is to use the "text to columns" option on your data tab on the ribbon. This will split any sentence in a cell for you and its pretty easy to use but you can only do one cell at a time.
Thu 29 Mar 2012, 11:26Trainer Rodney said...
RE: Splitting text using functions
Hello Anuja,
I had a look at this forum post and thought you may like some more information. I have attached a file which has a few examples using LEFT / RIGHT / LEN / MID / SEARCH functions. Hope this helps.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
Thu 5 Apr 2012: Automatically marked as resolved.
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:Select blank cells automaticallyGet Excel to find any blank (empty) cells in a region for you by: |
