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)
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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.