concanate formula

[hafiza]

what is wrong with my formula?

=concatenate(mid(a1, 75), "092008", mid(a1, 82, 149))

anyone can help.........

 

[T. Valko]

You're missing an argument in the first MID function.

mid(a1, 75)

 

[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

 

[hafiza]

Thanks alot

I manage to get it right

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