Скачать или смотреть Extract the text BETWEEN two delimiters in Excel

00:00 Extract the text BETWEEN two delimiters in Excel
00:42 Use FIND to find the character number of the first delimiter
01:40 Extract the first characters (before the first delimiter)
02:13 Find the character number of the 2nd delimiter
03:13 Extract the characters AFTER the last delimiter
03:50 Extract the character BETWEEN two delimiters in Excel

The FIND functions tells you the starting position of characters you are searching for within a cell. In this example we have some information here which we have extracted from our computer system. What we want to do is extract the product name, product code and then the unit size out of it. But as you can see there is no standard length here. So what we need to do is some how find out in each cell where this hash sign is and then extract the applicable characters.

We can use the FIND function to find at what position this hash is located. So if I click in this cell, where we are going to identify the character of the first hash, I activate the function wizard, go to text, and you will see there is FIND here, and say OK. What you will see now is it gives us a bit of information so first it tells us give us the starting position, it does specify that FIND is case sensitive. So it says FIND the text, and in this case we know we want a hash and we put it in inverted commas, within text, we are going to point it here and it asks for the start number and you will see you can leave it out or you can specify to start at number 1 so I will say 1. We can say OK. You will see it tells us that this hash is at point 20.