H
hafiza
what is wrong with my formula?
=concatenate(mid(a1, 75), "092008", mid(a1, 82, 149))
anyone can help.........
=concatenate(mid(a1, 75), "092008", mid(a1, 82, 149))
anyone can help.........
T
T. Valko
You're missing an argument in the first MID function.
mid(a1, 75)
mid(a1, 75)
S
Shane Devenshire
Hi,
The MID function needs 3 arguments.
Also you might write this as
=MID(a1,75,4)&"092008"&MID(a1, 82, 149)
Cheers,
Shane Devenhire
The MID function needs 3 arguments.
Also you might write this as
=MID(a1,75,4)&"092008"&MID(a1, 82, 149)
Cheers,
Shane Devenhire
H
hafiza
Thanks alot 
I manage to get it right
I manage to get it right
Shane Devenshire said: