=INDIRECT(ref_text, [a1])
Here, we have sample database and want to convert texts into cell reference:
We will be using INDIRECT function as follows:
– If no value or “TRUE” provided in [a1] argument, by default it considers ref_text as A1 style
– If [a1] argument is “FALSE” then it considers ref_text as R1C1 style
–A1 style means: columns are presented using letters (A-Z) and rows using numbers (1,2,3…)
–R1C1 style means: rows are presented using R1, R2, R3… and columns are presented using C1, C2, C3.
Hope you learnt this Function,
Don’t forget to leave your valuable comments!
LEN function is used for counting number of characters in available string. The output of the function returns the count in new cell.
Microsoft Excel “NOW” function is used to get the current Date and Time. It is very useful function and can be used in many ways.
Excel Function- WORKDAY.INTL WORKDAY.INTL function is an advanced version of WORKDAY function with additional advantage of “Custom weekend options” For Example, with WORKDAY function weekends are treated as “Saturday and Sundays” however if you need…
CONCATENATE function is used for combining two or more Microsoft Excel strings into one. The output of the function returns as a combined string in new cell.
SUBSTITUTE function is used to substitute the existing old text to new text.
ROUND function rounds the number value to nearest digit mentioned in argument.
ROUND function has two required arguments i.e. number and num_digits