Thread: finding numbers
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
johnrb7865 johnrb7865 is offline
external usenet poster
 
Posts: 20
Default finding numbers

Hi, does anyone know how I would pull numbers out of a string of text? For
example, the text: Prepare Culvert Pipe (30 Inch), I need a formula to
display just the "30". The text strings will vary so I cannot use MID to pull
out text at certain spots. Any thoughts?

Thanks,
John