Forum Discussion

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
Sep 15, 2022
KAM_Mumin
=MID(E4,FIND("box ",E4)+4,LEN(E4)-2-(FIND("box ",E4)+4))
You can try this formula.

OliverScheurich

Gold Contributor

Sep 15, 2022

KAM_Mumin

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

You can try this formula.