Concatenation with Pocket Excel

[Guest]

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

 

[Guest]

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

Thanks!

Ian