Thread
:
How to get the number from text?
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Teethless mama
external usenet poster
Posts: 3,718
How to get the number from text?
=TEXT(LOOKUP(10^10,MID(A1,1,ROW(INDIRECT("1:"&LEN( A1))))+0),"000")
"JJ" wrote:
I have data as this format: 025BNN, 033WGN, I want to get only the numbers
from the text. how can i do that? thx.
Reply With Quote
Teethless mama
View Public Profile
Find all posts by Teethless mama