concanate formula

H

hafiza

what is wrong with my formula?

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

anyone can help.........
 
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
 
H

hafiza

Thanks alot :)

I manage to get it right :)

Shane Devenshire said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Value of the first day of a year in a list 5
Excel - Wich Function should I use? 1
Lookup against concatenated source value 4
Mid and isnumber 2
Converting from Decimal to Base-36 in Excel Formula 3
somewhat complicated conditional formula 2
Remove punctuation mark, Split cells & average accross column 4
VLOOKUP source values are a formula result. Getting #N/A 7

Top