Formula Help

[Farha]

Query
FOR EXAMPLE I HAVE THIS FORMULA IN A1 AS TEXT (RIGHT(INDIRECT("H"&ROW()),9)) AND I HAVE TO CALL THIS FORMULA IN A2 I AM DOING =A1 BUT NOT WORKING THEN I AM DOING INDRECT(A1) BUT NOT WORKING PLEASE GUIDE SOLUTION.
REGARDS FARHAN

Formula As Under Mentioned.
RIGHT(INDIRECT("H"&ROW()),9)

 

[Mike86]

If the cell you're wanting to pull nine characters from with this formula is in H1, the formula should work. Referring to this formula in A1 from cell A2 should work.

Why are you trying to use the indirect function in this case? You could just use =RIGHT(H1,9)?

A more complete answer may be possible if you could upload the file you're working with.

 

[Farha]

Mike86 Thanks You for Reply kindly note i have pasted row() function mean when i will apply this formula it applies to H Column on current row.

i hope it conveyed.

Regards,

 

[NARAYANK991]

Hi ,

The formula is :

=(RIGHT(INDIRECT("H"&ROW()),9))

which will return the right-most 9 characters of what ever text is present in the corresponding cell in column H.

Cell A1 should contain the above formula , as a formula , and not as text.

If cell A1 contains the above formula , then cell A1 will display the right-most 9 characters of what ever text is present in cell H1.

Entering =A1 in cell A2 will display the same contents of cell A1 in cell A2.

Narayan

 

[Farha]

I have Already Told you that formula is there as text. Please suggest how to call text as formula as Indirect not working and = also not working.
Regards Farhan

 

[bobhc]

Perhaps you should take a moment to read the rules

Please Don't

• PLEASE DON'T SHOUT! We have big ears and will hear you just the same.
• Please don't post a question to

Using all UPPER CASE is forum bad manners and it makes the post difficult to read.

I have Already Told you that formula is there

This is a global site and as such members have different English skills, but if you address members as you have there is a good chance the help you receive will diminish.

.

 

[Farha]

Respected Bobhc,

Kindly refer to my post instead of having grammatical mistakes in English however i think this is an Excel forum but litterly i have very quick reply on English grammar and manners instead of my Excel problem.

Kindly do accept my apology and next time i will take care about English grammar.

Take this reply positive and kindly advise upon my query.

Regards
Farhan

 

[NARAYANK991]

Hi ,

If the contents of cell A1 are text , then I do not know how it can be done using a formula.

Narayan

 

[Mike86]

Just to speed this along, here's the functioning equation using the RIGHT function with INDIRECT and with a simple cell reference on separate tabs. Both work, problem resolved?