Thread: Excel help
View Single Post
  #5  
Old 7th July 2009, 07:24 PM
Shaun Shaun is offline
Member
  
Join Date: Jan 1970
Location: Western Australia
Posts: 3,456
Default
i think that excel dude made a mistake on his formula
=MID(A1,SEARCH("$",A1)+1,SEARCH("k",A1)-SEARCH("$",A1)-1)
Reply With Quote