Thread: Character as a Number
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Jani Jani is offline
external usenet poster
  
Posts: 31
Default Character as a Number
I got it figured out! Thanks!

"Gary''s Student" wrote:

=(MATCH("*",A1:E1,0)-1)*2
for the first four cells in row 1

No IFs were needed
--
Gary''s Student - gsnu200805
Reply With QuoteReply With Quote