Here, we will see how we can get dynamic output with a simple function.
For example, assume that you have an Excel sheet having some 2000 web domain names ending with forward slash “\”
How will you remove that forward slash “\” from the list?
Using LEFT command, we can get the result.
Syntax
=LEFT(text,[num_chars])
text = > Select the cell data
num_chars = > Number of characters you want to fetch
Domain list
=LEFT(A2,24)
24 = Number of characters in the cell.
In =LEFT(A2,24) number 24 has to change based on cell length
By using another simple formula, LEN, you can find the number of characters in the cell.
Syntax=LEN(text) = It will tell us number of characters in a cell
Now, using both LEFT and LEN, we can get dynamic results.
Very useful website for all .great job . Thanxs .all the best
Thank you Anwar
Supper sir, we know u will rock keep continue your job. All the best
Thank you
Excellent initiative. Hope this will help lot of people who are in need of excel learning. Many wishes to you.
Thank you andrews
Hi prasad
Good and get going on this
Hi… Really useful and easy to learn everything in excel…Awesome idea.. Keep rocking….