Forum Discussion

Xaraox_'s avatar
Xaraox_
Copper Contributor
Jan 27, 2023
Solved

Formula problem

Hi all,   I need some help for my excel formula   I need to add numbers before a formula number(just like the photo). What i should type this if i need to do this? Thank you guys so much for the ...
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Jan 27, 2023

    Xaraox_ 

    =NUMBERVALUE("7"&RIGHT(A14,1))

    Does this return your expected result?

     

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Jan 27, 2023

Xaraox_ 

=NUMBERVALUE("7"&RIGHT(A14,1))

Does this return your expected result?

 

  • Xaraox_'s avatar
    Xaraox_
    Copper Contributor
    Jan 27, 2023
    Yes, Thank you so much for it.

Resources