View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default 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