Excel Magic Trick 454: Get Last Number or Word or Anything 4 Amazing LOOKUP functions

See 4 formulas using LOOKUP function to look up last number, or last word, or last items no matter if it is a word or number. Learn about the important numbers:
1)9.99999999999999E+307 is the biggest number that Excel can understand Big Num
2)255 is the max number of characters that lookup_value can be
3)2 is bigger than all the 1s generated from a list of TRUEs.

Category:

Science & Technology

Tags:

• Excel
• LOOKUP
• function
• last
• number
• word
• or
• items
• no
• matter
• if
• it
• is
• excelisfun
• Mike
• Gel
• Girvin
• Highline
• Community
• College
• Big
• Num
• BigNum
• Biggest
• Number
• Word
• that
• can
• see
• Aladin
• Mr
• Message
• Board

[ALIKALVERT]

i ment do you know how to convert numbers to words automatically

for eg :- i type 4000/- in one cell and it automatically converts it into (four thousand only) in another cell

[ExcelIsFun]

Watch this video:

Excel Magic Trick 276 MoreFunc Excel add-in 66 New functions

Then use NBTEXT

Did you check your add-ins to see if MoreFunc is still added in?

[ALIKALVERT]

i wanted the download to convert number into text eg :- 4420/- convert automatically to

four thousand four hundred & twenty only)

the formula to convert is =nbtext

but since i formated my system i am not able to do it any more

[ExcelIsFun]

I don't know what you mean by "formated my system". Do you check your add-ins to see if MoreFunc is still added in?

[chavan2000]

Hi Sir,

The excel workbook is missing on your site. Hence request you to upload it.

Regards

Heera Chavan

[ExcelIsFun]

I just uploaded the workbook!

[jonyung06]

i guess the last number is this 452514854545213245541485418541­545151032265454962645654654584­156489456542365654654564654656­418465785474267865495648946546­548454654885454545476565496549­874974578444658683838959527641­672432825324552464658554015554­066565265262967210542814011846­569748901154055454165401654054­054206165054045458545001401251­540154054523510650545054556464­654646540604604106458424102154­054840840545405054555525325832­824561657324655405865721047254­252528557851552542543273245245­542553586386897975

[ExcelIsFun]

I am sorry about that. I have to go to my office to upload it. I am not sure if I will be in on Friday (probably) or not again until Monday...