Remove Text without Array Formula

[vaibhavmodia]

I want to remove text from my given formula. Please guide me. You can also use any other formula but please don't use array formula. My file size is very big so I don't want to make it bigger with use of array formula.

Please guide me as soon.

 

[bosco_yip]

Please see attached file

Regards

 

[vaibhavmodia]

Please see attached file

Regards

Thank you very much for your reply. But my range is very big. This formula is not working correctly after row no. 102, please check the excel file.

Thanks.

 

[vaibhavmodia]

Please see attached file

Regards

Thanks dear,

It is solved now. You really helped me. Thank you so much.

 

[CA Rohit]

I want to remove text from my given formula. Please guide me. You can also use any other formula but please don't use array formula. My file size is very big so I don't want to make it bigger with use of array formula.

Please guide me as soon.

Try this excel. Simplified version. Only thing is that we follow the same pattern

 

[CA Rohit]

Thank you very much for your reply. But my range is very big. This formula is not working correctly after row no. 102, please check the excel file.

Thanks.

Just had a query. I have compared both the formulas and i think your's is giving slightly different answer. Could you please check and help.

 

[vaibhavmodia]

Just had a query. I have compared both the formulas and i think your's is giving slightly different answer. Could you please check and help.

Hello sir,

I think it is the best solution. It is very simple to use and I get the proper result.
Thank you Very Much for your help.

Thanks.