Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
concanate formula
what is wrong with my formula?
=concatenate(mid(a1, 75), "092008", mid(a1, 82, 149)) anyone can help......... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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......... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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......... |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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......... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|