How to set Custom Formatting via Formula?

[krunal123]

My Formula Problem this above condition , Not show Proper Format

We Need this Format Result : EXP/025/21-22

Kindly Correction Below Formula , and Show Perfect Formula in this case

=LEFT("EXP",3)&"/"&MID(A2,5,3)&"/21-22"

Help me !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

 

[arthurbr]

Try

="EXP"&"/"&A1&"/21-22"

 

[krunal123]

Try

="EXP"&"/"&A1&"/21-22"

I need Perfect formula in this condition

 

[arthurbr]

Does that mean the solution is what you need?

 

[krunal123]

Does that mean the solution is what you need?

=LEFT("EXP",3)&"/"&MID(A2,5,3)&"/21-22" kindly Correction This formula Check Above image

 

[arthurbr]

I don't undertsand what you are trying to do
LEFT("EXP",3) is redundant as EXP only has 3 characters
MID(A2,5,3) ? A2 has only three characters, so extracting from the 5 th character on is impossible

 

[krunal123]

I don't undertsand what you are trying to do
LEFT("EXP",3) is redundant as EXP only has 3 characters
MID(A2,5,3) ? A2 has only three characters, so extracting from the 5 th character on is impossible

This formula using =LEFT("EXP",3)&"/"&MID(A2,5,3)&"/21-22" , my formula mistake

so kindly Correction This formula Check Above image

we need this Result : EXP/025/21-22 << This format via formula

 

[arthurbr]

What is wrong with my above suggestion then?