Thread: extract text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
choice choice is offline
external usenet poster
 
Posts: 18
Default extract text

if i have different text strings, but in all of them there will by a dollar amount

example:
aif2ffsdfij$39.99&3kgjcis
o
qe141$29.99.cw.e.331

how would i go about extracting the formul