Hi,
# represents any single characterHi Colin - i didnt refresh! as an aside - what do the # and ~ wildcards do?
~ means that the following character should be treated as a literal, not as a wildcard. So you use it when you're summing against cells which contain * or # or ~.
Bookmarks