Stand for your beliefs. When the foe comes against us, We fight to keep ground. © Levi Wooten, 2023
Author Archives: LeviWooten
Ought to be set by our needs,
Not by others wants.
© Levi Wooten, 2023
Troubles pass your way.
Be the best that you can be,
Choose to be Awesome!
© Levi Wooten, 2022
A cloud that appears. But as with every storm cloud, It will soon vanish. © Levi Wooten, 2022
If you are feeling down, just remember, this is just a short amount of time till it passes. Scientist can’t measure how dark a place is, but only by how much light exists. Even if you feel that you are trapped in a box, there still light outside that box. You only need someone to open that box to let the light in. Find that small bit of light and cling to it.
Count Specified Characters in a Cell
Have you ever wanted to know how many specified characters are in a cell? You can do this with a fairly simple formula.
- LEN – LEN(str): Length of string
- SUBSTITUTE(str, new_str, old_str) – Replaces all specified string with another specified string
Create a string within a cell.
To find out how many “A” are in the text, as in the example above, use the following formula:
What is happening in the Formula
Len(B4) is counting the total number of characters in the string, for this instance it is 6.
Substitute(B4,””,”A”) is replacing the text “A” in cell B1 with an empty string, thus removing the text from the string. We are then running the length function on the substituted text “BBCCC” thus returning 5.
The formula subtracts the substituted length from the original length of the string, returning the difference which is 1.
Civil engineer, Or uncivil engineer. Choice, is yours to make. © Levi Wooten, 2022
Coin flip to start game.
Excessive energy burnt,
To get quarter back.
© Levi Wooten, 2022
Look into yourself, Find you reason to succeed. Then calm can be found. © Levi Wooten, 2022
Morning it exist, But I'm a better person. Continue, smiles. © Levi Wooten, 2022
I am Terrified, But I keep my head held high With God and Family © Levi Wooten, 2022