Concatenation with Pocket Excel
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
|