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?
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.
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
