Text Find Formula.

[sachar]

Dear All,

With reference to the attached sample file, May I know what is the wrong with “FIND” formula in Column “B” that is returning the value “#VALUE”?

 

[Ramesh]

Try the formula given below

=FIND(",",TEXT(A1,"#,##0"))

 

[sachar]

Dear Ramesh,

Thanking you.

 

[Khalid NGO]

May I know what is the wrong with “FIND” formula in Column “B” that is returning the value “#VALUE”?

Hi sachar,

You have the solution, I just want answer your query.

Your cell is formatted to look so, the cell contains real numbers; The thousand separator and 2 decimals are actually not in your cell:



FIND function is unable to search the "comma" , hence ERROR.

Regards,