Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default What is the furmulla to extract Rs.44325/t

if any one have excel functions file then please send in my email Id

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 860
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
extract name Shamu Excel Discussion (Misc queries) 3 August 13th 07 12:55 PM
How can I extract each Max key value ? diglas1 via OfficeKB.com New Users to Excel 2 May 31st 06 11:06 PM
Extract Unique Values, Then Extract Again to Remove Suffixes Karl Burrows Excel Discussion (Misc queries) 23 June 25th 05 10:37 PM
extract from worksheet alisonmacd New Users to Excel 6 June 21st 05 10:24 AM
Last Name, First Name extract Tony Excel Discussion (Misc queries) 2 May 13th 05 01:06 AM


All times are GMT +1. The time now is 03:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"