On 02/01/2011 11:26 AM, Michael D. Roush wrote: > On 2/1/11 11:13 AM, . wrote: >> >> How do I get Calc to put any year (listed in cell A1) and the month >> (listed in B1) into C1 so that it would look like this; January 2011 > > Given that you have "2011" in cell A1, and "January" in cell B1, the > correct formula for cell C1 would be: > > =CONCATENATE(B1;" ";A1) > > This will take the text from B1, put a space after it, and then the > text from A1. Result... "January 2011". > > Michael
Perfect! Thank you so much. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@openoffice.org > For additional commands, e-mail: users-h...@openoffice.org >
signature.asc
Description: OpenPGP digital signature