Forum Discussion

KAM_Mumin's avatar
KAM_Mumin
Brass Contributor
Sep 15, 2022
Solved

MS Excel First Name/Last Name Formula

Hi Everyone! Here I want to get the first value and the last value look like I have (462 box 0 pcs) in a cell and I want to get the first value 462 which give me the count of box and then need the v...
developer
excel
Formulas and Functions
Macros and VBA
Office Scripts
  • OliverScheurich's avatar
    OliverScheurich
    Sep 15, 2022

    KAM_Mumin 

    =MID(E4,FIND("box ",E4)+4,LEN(E4)-2-(FIND("box ",E4)+4))

    You can try this formula.

     

Nothing_Left_to_Lose's avatar
Nothing_Left_to_Lose
Brass Contributor
Sep 15, 2022

KAM_Mumin 

 

The NumsLeft and NumsRight functions are part of the free 'Custom_Functions' Excel add-in.

(20+ excel functions that work exactly like the built-in excel functions)

 

Download from OneDrive...

https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU

 

 

'---

Nothing Left to Lose

Resources