By SCTo check length of the word or to check how many letters or character in cell we can use len formula as shown below
LEN Formula in Excel:
=len(A1) will always return the output in number.
It can also be used with Left right formulas in excel.
This blog is about working with data by using different tools Excel ,Python, Access Power automate etc .
[…] we have to remove last two digits from it then We can use at a place formula with combination with length […]