View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Mixed Text & Numbers

I have a row of numbers, which can be 2 or 3 digits long. Some have * before
the numbers, some don't. I want another cell to be able to read the numeric
value if the cell has an * before it. Any ideas? I'm stuck.