Text Formulas – LEFT(), RIGHT() & SEARCH() - 2 of 2

2 minutes
Share the link to this page
You need to purchase the class to view this lesson.
One-time Purchase
List Price:  $139.99
You save:  $40
List Price:  د.إ514.18
You save:  د.إ146.92
List Price:  A$195.60
You save:  A$55.89
List Price:  ৳11,872.36
You save:  ৳3,392.34
List Price:  CA$187.37
You save:  CA$53.54
CHF 91.26
List Price:  CHF 127.77
You save:  CHF 36.51
List Price:  kr884.75
You save:  kr252.80
List Price:  €118.74
You save:  €33.93
List Price:  £107.27
You save:  £30.65
List Price:  HK$1,084.99
You save:  HK$310.02
List Price:  ₹10,502.85
You save:  ₹3,001.03
List Price:  RM586.20
You save:  RM167.50
List Price:  ₦52,986.21
You save:  ₦15,140
List Price:  kr1,265.84
You save:  kr361.69
List Price:  NZ$211.96
You save:  NZ$60.56
List Price:  ₱6,870.27
You save:  ₱1,963.07
List Price:  ₨23,504.32
You save:  ₨6,716
List Price:  S$192.17
You save:  S$54.91
List Price:  ฿4,370.86
You save:  ฿1,248.90
List Price:  ₺1,021.10
You save:  ₺291.76
List Price:  R2,469.09
You save:  R705.50
Already have an account? Log In


Hello everybody. In this video session we'll talk about search formula and how it can be used help extract the data. So, search formula What does it do? Let me give you a brief example first by writing the search formula, it says which kind of text what kind of text Do you want to find I say, I want to find the placement of the space and hence in a pair of double quotation I have put in a space. Now it tells me within what text in this text, what it gives me is this positioning that means running is five character name and followed by the space which is on sixth position. Now where is it used?

Quite often, you would want to use this in combination of formulas like left or right or made depending on what kind of character you are looking at. So for example, if I want to extract the data of all the names using left formula, in the left formula, I must know that How many characters do I need to extract in this case five. But of course, that is not going to hold true had the name been a very simple one like son. Because if I do that, it not only extract the sun but also the space and the for thereafter. So what I need to do is in place of that hard coded five, I am going to insert a search formula. Notice I've closed another parenthesis to ensure search formulas complete from the point of your parentheses.

Now within search, I say look for find what find that one space, comma, then I choose to sell. But when I press enter, you'll notice as I copy paste down, it might take all the names, but the length of the data is not going to be what it looks like. Six Why? Because it has taken not only the names but also one space. Why? Because search was looking for the placement of space.

So eventually what you might want to do is towards the end of search formula, notice where have I put my cursor. So towards the end of search formula, and within the left formula, I'm putting a minus one. So now it's a perfect Ronnie without the space. That's where you see the lenise five. So this was an example of how search can be used in combination wealth lift formula.

Sign Up