Hello, I am trying to build a formula in Cell D1 (down to D100)
It is based around wheat is in A1 (down to A100).
Some of the data in A1 is pure number, some is pure text, and some is a mixture.
What I want D1 to do, is, if the first character in A is a number, then show it in D1. If it's text (or a non number) show blank ""
Bookmarks