View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dstiefe dstiefe is offline
external usenet poster
 
Posts: 73
Default capturing text to the right

Remaining Balance on Invoice: $1,000.00

the text above is in a cell..i have thousand of cells in column like this

how do i capture just the "$1,000.00" amount. because this amount is
sometimes a 1,000 and sometimes 10,000

Thank you