ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   What is the furmulla to extract Rs.44325/t (https://www.excelbanter.com/excel-worksheet-functions/157235-what-furmulla-extract-rs-44325-t.html)

Post a new question

What is the furmulla to extract Rs.44325/t
 
if any one have excel functions file then please send in my email Id


David Biddulph[_2_]

What is the furmulla to extract Rs.44325/t
 
Your question isn't clear. If you are saying that you have a text string
like "Rs.44325/t" in a cell, and you want to extract the number 44325, then
try
=--MID(A1,4,LEN(A1)-5)
--
David Biddulph

"Post a new question" <Post a new wrote
in message ...
if any one have excel functions file then please send in my email Id




MartinW

What is the furmulla to extract Rs.44325/t
 
Hi,

I imagine you are trying to extract data from an electronic recording
device and display the results in an excel spreadsheet.

You would probably get better results searching for a more compatible
newsgroup, perhaps an electronics newsgroup or even a surveying
newsgroup. Surveyors deal with this sort of problem although they
usually get someone technical to set it up for them.

HTH
Martin


"Post a new question" <Post a new wrote
in message ...
if any one have excel functions file then please send in my email Id





All times are GMT +1. The time now is 12:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com