hello ,

So , the task is to merge data that includes both text and numbers in one cell . now once i do it using the & function , i m required to delete the data from other cells . for example - if the data from A16 and B16 is merged in C16 , then the data in A16 and B16 needs to go , but when i do that , obviously there is nothing left in c16 as well . how can restore c16 ?