LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9
Default Find a phrase in a string and convert it to a number

I´m able to find a specific phrase in a string. But when this is a number the
result is still a text cel. What is the worksheet function I can use to
convert the result into a number ? I don´t want to copy and past the value
(past special - values only), because I want to keep the formula instead of
use the value.


 
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
convert string to number Jeff Klein Excel Worksheet Functions 4 November 1st 07 10:01 PM
convert a text string to a number kevcar40 Excel Discussion (Misc queries) 7 July 4th 07 03:58 PM
Convert a number to phrase Shahrun A Rahman Excel Discussion (Misc queries) 2 May 7th 07 12:46 AM
Convert a number to a name string Numbers to name string Excel Worksheet Functions 2 June 23rd 06 04:52 PM
convert string to number Christina Excel Worksheet Functions 3 November 16th 04 02:36 PM


All times are GMT +1. The time now is 03:25 AM.

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

About Us

"It's about Microsoft Excel"