Write a excel nested formula

[samy (Sandra Vargas)]

Good morning, if someone has worked with formulas in excel, I thank you for guiding me how I can write a nested formula

I need to put the following formula in an excel cell :

“=CONCAT(IZQUIERDA(A2;11);“2”;DERECHA(A2;4))”

Thanks!!!

[prasath17 (Guru)]

@samy

“=CONCAT(IZQUIERDA(A2;11);“2”;DERECHA(A2;4))”

Please try like this…

[samy (Sandra Vargas)]

@prasath17 thank u so much!!! it´s correct