Hi,
I'm trying to concatenate 4 text strings, and whether I use the concatenate formula or the "&" symbol, it always returns as zero. Any ideas why? I have tried formatting both the source and destination cells as 'text' and as 'general' and yet I get the same result.
A few points:
- formulas are on automatic
- the 4 text strings all have formulae in them (they're if statements)
- i have moved between excel 2003 and 2007 in making this workbook, but the only formulae in use are compatible with both
Any help would be very much appreciated.
Thanks,
jonnya
Bookmarks