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

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

NickHK

"R. Ian Lee" wrote in message
...
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

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" wrote in message
...
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