Concatenation with Pocket Excel

[R. Ian Lee]

Hi,

I trying to create a formula in Pocket Excel (WM 5.0) that will simply take
a source column of dates in the format "1/1/2006" and put only the month and
year into a new column in the format "1/2006" to be used by a chart. In the
desktop of Excel I would just use:

=CONCATENATE(MONTH(A1),"/",YEAR(A1))

However, I've discovered that Pocket Excel doesn't support the CONCATENATE
function. Is there an alternative way to do this (without creating new
columns of date for month and year)?

Also, it seems that I cannot do a CTRL click type select and select columns
of data that are not next to each other. Am I overlooking something or does
this functionality just not exist?

Thanks,

Ian

[NickHK]

Ian,
I don't use the Pocket version, I would assume it supports
MONTH(A1) & "/" & YEAR(A1)

NickHK

"R. Ian Lee" <RIanLee@discussions.microsoft.com> wrote in message
news:5F0ADE80-7486-4C29-A8B5-A4802C9AB594@microsoft.com...
> Hi,
>
> I trying to create a formula in Pocket Excel (WM 5.0) that will simply
take
> a source column of dates in the format "1/1/2006" and put only the month
and
> year into a new column in the format "1/2006" to be used by a chart. In
the
> desktop of Excel I would just use:
>
> =CONCATENATE(MONTH(A1),"/",YEAR(A1))
>
> However, I've discovered that Pocket Excel doesn't support the CONCATENATE
> function. Is there an alternative way to do this (without creating new
> columns of date for month and year)?
>
> Also, it seems that I cannot do a CTRL click type select and select
columns
> of data that are not next to each other. Am I overlooking something or
does
> this functionality just not exist?
>
> Thanks,
>
> Ian

[R. Ian Lee]

That got it! I had tried that except using "+" instead of "&" and it didn't
work...

Thanks!

Ian

"NickHK" wrote:

> Ian,
> I don't use the Pocket version, I would assume it supports
> MONTH(A1) & "/" & YEAR(A1)
>
> NickHK
>
> "R. Ian Lee" <RIanLee@discussions.microsoft.com> wrote in message
> news:5F0ADE80-7486-4C29-A8B5-A4802C9AB594@microsoft.com...
> > Hi,
> >
> > I trying to create a formula in Pocket Excel (WM 5.0) that will simply
> take
> > a source column of dates in the format "1/1/2006" and put only the month
> and
> > year into a new column in the format "1/2006" to be used by a chart. In
> the
> > desktop of Excel I would just use:
> >
> > =CONCATENATE(MONTH(A1),"/",YEAR(A1))
> >
> > However, I've discovered that Pocket Excel doesn't support the CONCATENATE
> > function. Is there an alternative way to do this (without creating new
> > columns of date for month and year)?
> >
> > Also, it seems that I cannot do a CTRL click type select and select
> columns
> > of data that are not next to each other. Am I overlooking something or
> does
> > this functionality just not exist?
> >
> > Thanks,
> >
> > Ian
>
>
>