SOLVED

Formula problem

Copper Contributor

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 help.

image.png

2 Replies
best response confirmed by Xaraox_ (Copper Contributor)
Solution

@Xaraox_ 

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

Does this return your expected result?

numbervalue.JPG 

Yes, Thank you so much for it.
1 best response

Accepted Solutions
best response confirmed by Xaraox_ (Copper Contributor)
Solution

@Xaraox_ 

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

Does this return your expected result?

numbervalue.JPG 

View solution in original post