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 ""
Maybe:
=IFERROR(--LEFT(A1,1),"")
Try,Formula:
Please Login or Register to view this content.
If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.
If your requirement has been solved please mark your thread as Solved.
In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".
Kindly use [FORMULA] or [CODE] tags when posting your code.
Regards,
Sarang
Hello regulduy, thanks - I should have said that some of the numbers are 4 digits as well. Your formula seems to work, but only returns the first digit (I use that as a check to see if the cell contains a number)
Hello Saarang84 - Thank you. That works (with a slight modification)
That's a bit tricker, try something like:
=LEFT(A1,MAX(IF(ISNUMBER(--LEFT(A1,ROW(A$1:A$1000))),ROW(A$1:A$1000),"")))
as an array formula (confirm with ctrl+shift+enter)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks