Find and Search Formula in excel
The Find and search function is used to find text or characters in cell. Both will return the number at…
July 2021
Formulatext function in Excel
t is used to document formula of a cell in sheet.
Text Join in excel
It is used to join two or more cells and have more useful than concatenate function in excel. It can…
Inner Join and Outer Join in SQL
nner Join in Sql will returns common elements in both tables as output.If A and B are Two table it…
Str.isprintable
It returns True if string is contains printable element or string is empty other vise returns False.
Str.isnumeric
It returns True if elements in string are numeric(0,1,2,3 etc.) else returns false.
Str.islower
It returns True if element in string are in lowercase else false if any one of the characters is capital.
Str.isidentifier
It returns True if string is valid identifier as per language otherwise returns False.
Str.isdigit
It returns True if all the element in string are digits otherwise returns False.
Str.isdecimal
ns True if decimal numbers(0,1,2,3) present in string otherwise returns False. Decimals numbers are numbers with base 10 in numbers…