If I set up the following, from a previous Applemac - from a “Superuser“ - excel solution.

(Combine 3 columns into one in excel 2011 for mac)

I enter column D to use the formula =CONCATENATE(A1,B1,C1) = it Works thus far. the prior instruction’s then say “Then delete columns ABC“ +++ If I then delete (columns ABC) the “Needed” (D Column) formula disappears in error’s.

Is it possible,

Then to change column D, or even Column E, into a firm useable numerical total.
Ie = [01234567890] (11 Characters) in either - column‘s D or E or Any Column.

**** My problem is part of several thousands of telephone customers+Suppliers+Friends phone numbers, are now in 3 Column’s of Excel work books, which I need, for dialling purposes into one Column Characters (2+3+6=11) Characters, in UK Phone Numbers.

In England - Column A is the UK- (01 (Work/Home nos)),

or (UK-07(Mobile Nos)) [ie we will use (01)]

Column B is (Three characters for an Area Type Code) [ie use (234)]
Column C is the Actual Six Characters - personal Number [ie use(678901)

= (creating the Needed Total of (11 Eleven) Characters ie Total - (01234567890)

Is it possible, then to make column D, or any other Column say (E), into a firm useable total, And then get rid of the Concatenated Columns (A,B,C,D).

Your help would be greatly appreciated

Ken Goodwin