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: 32
Default Search Function Question

How can you make the Search function find a number (any number) in a text
string?

In this example, I would like Search to locate the first number (not just
the number 1, which is in the formula below) after a defined point in the
text string:

SEARCH(1,B2,LEN(TEXT(C2,"d,m,yyyy"))+15)

--
iperlovsky
 
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
Question regarding how to search a column and print a row(s) PegL Excel Discussion (Misc queries) 0 July 15th 05 03:15 PM
Question regarding how to search a column and print a row(s) PegL Excel Worksheet Functions 0 July 15th 05 03:15 PM
Question regarding how to search a column and print a row(s) Max Excel Discussion (Misc queries) 0 July 15th 05 04:14 AM
Search and Replace Question Rebecca New Users to Excel 1 April 11th 05 04:49 AM
Simple Search and Replace Question Rebecca Excel Discussion (Misc queries) 2 April 3rd 05 03:33 PM


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

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"