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 =  (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