ExcelBanter - concanate formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - concanate formula (https://www.excelbanter.com/excel-worksheet-functions/211533-concanate-formula.html)

hafiza

concanate formula

what is wrong with my formula?

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

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

T. Valko

concanate formula

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

mid(a1, 75)

--
Biff
Microsoft Excel MVP

"hafiza" wrote in message
...
what is wrong with my formula?

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

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

Shane Devenshire[_2_]

concanate formula

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" wrote:

what is wrong with my formula?

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

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

hafiza

concanate formula

Thanks alot :-)

I manage to get it right :-)

"Shane Devenshire" wrote:

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" wrote:

what is wrong with my formula?

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

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

All times are GMT +1. The time now is 09:40 AM.