CONCATENATE not producing any results
It sounds like the cell is pre-formatted as Text. Change the format to
General, then re-enter your formula (without the apostrophe at the beginning). A shorter way to set up the formula is: =D10 & D11 Hope this helps. Pete On Feb 19, 4:52*pm, JennieSarah wrote: Hi; Im hoping that im making a really silly error here myself but I really cannot see whats wrong and getting frustrated! Im using the Concatenate function within my worksheet but after setting up the function and pressing the enter key, nothing happens at all. No result is shown for the formula, just the formula itself is displayed within the cell: '=concatenate(d10,d11)' I have already checked to make sure that the worksheet is not set up to show the formulas and have tested out anything that I think could be affecting it but to no avail. Are there certain types of cell contents that cannot be used with this function or is there something that I am missing perhaps? Any help is greatly, greatly appreciated! Many thanks, Jen |
All times are GMT +1. The time now is 05:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com