I have a worksheet of 3 columns of data: Title, First Name, Last Name. How can I merge these columns so that I have one column that contains all 3 fields, i.e Mr John Smith.
I know that you can parse text in the opposite direction to seperate names into different columns (using text to columns) but cannot find a way to do this in reverse.
Many thanks
Graham
