Splitting text using functions

Resolved · Medium Priority · Version 2007

Mon 26 Mar 2012, 16:24 Delegate 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:08 Trainer 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:26 Trainer 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 courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Select blank cells automatically

Get Excel to find any blank (empty) cells in a region for you by:

1. Selecting the appropriate region from your spreadsheet.

2. On the menu bar, go to Edit - Go to.

3. Click the 'Special' button, then select Blanks and click OK.

View all Excel hints and tips