What is the furmulla to extract Rs.44325/t

  • Thread starter Post a new question
  • Start date
D

David Biddulph

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)
 
M

MartinW

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
 
Top