Hello Friends
I want to find the last number in light yellow cells the column may contain numeric or both alphanumeric.
B1 formula is example for texts. Please find the attached excel 97 version file <Find Last Number.xls>
thanks
thilag
Hello Friends
I want to find the last number in light yellow cells the column may contain numeric or both alphanumeric.
B1 formula is example for texts. Please find the attached excel 97 version file <Find Last Number.xls>
thanks
thilag
B2 for text only:
Formula:Please Login or Register to view this content.
E2 for numbers only:
Formula:Please Login or Register to view this content.
I2 for either:
Formula:Please Login or Register to view this content.
Dear Zbor
thanks for perfect solutions.
thilag
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks