There are 2 methods to split the cell contents in excel data sheet. First one is using "mid" function and second one is using "Text to Columns" option in "Data Tools" sub group in "Data" tab. Here I'm going to explain the use of "mid" Function.
If you are wish to download excel file that contains the example, Please click here
Let's understand the function. The basic format of the function is as below
=mid(text,start_num, num_chars)
- 'text' means the reference or text you want to split.
- 'start_num' means count of the text you want to start the split. (Count from left)
- 'num_chars means' the count of the characters you want to extract from the original text.
As an example, assume that we want to extract "iPhone" from "AppleiPhone". Then 'start_num' is 6 and 'num_chars' is 6 because text count for "iPhone" is 6. You have to consider spaces also as a character when you are using this function. (See the differences between row 3 and 4 in the example file)
No comments:
Post a Comment