Thread: Extract a percentage from a text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lok Tak Cheong Lok Tak Cheong is offline
external usenet poster
  
Posts: 14
Default Extract a percentage from a text
A1 is text: The increment is 5%
B1 is value and formula = 1000 * (increment in A1)
Can anyone help with this?
Thanks in advance,
Cheong


Reply With QuoteReply With Quote