extract char 5&6

[Trevor3007]

hi,

HR0810919

I only want to extraxct the 'red' text into another cell (char5&6) and prefix with Fl..

Tried, left, right & mid..but no luck

Does any have the solution for me?

MTIA
Trevor3007

 

[tyija1995]

Hey,

What did you input with MID function?

=MID(A1,5,2) should work. (Assuming A1 holds the text)

EDIT: To add prefix try ="Fl"&MID(A1,5,2)

 

[Trevor3007]

.....by the power of greyskull!!!

it works... good work , nice one . Thank you