Jan 27 2023 06:17 AM
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.
Jan 27 2023 06:35 AM
SolutionJan 27 2023 06:35 AM
Solution=NUMBERVALUE("7"&RIGHT(A14,1))
Does this return your expected result?