View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max
 
Posts: n/a
Default Array formula and #N/A

"Graham Haughs" wrote in message
...
That works for me Max. Strangely I get a small empty square character at
the end of the Free, but this is not important. Many thanks.


That's just a stray line break character <g, introduced unknowingly when
you copy pasted the formula direct from the post into the cell/formula
bar. Just dress it up by deleting the stray square character in the cell
before array-entering. The phrase should appear in the formula as just:
"Free".
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---