I have a problem with joining cells or columns after splitting them using 'Data – Text to Columns. I need to do this in order to sort on part of the column data e.g. on LastName where FirstName & LastName are entered in the same column.
Using the formula =CellRef&CellRef or =CONCATENATE(Cell...