|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
Merging 2 cells together and prefixing
="t: "&cell1&" "&cell2
"fuzzyjon" wrote:
Hi there
I hope someone can please help me with a problem that I have as shown
below:-
OK, I have a telephone number which is split into two separate cells.
The first cell is the dialling code (STD code) and the second cell is
the actual number. These cells are next to each other e.g. A1 and B1.
So, A1 = e.g. 01302 and B1 = e.g. 820353
I want to merge them into 1 cell so that the STD code and number are
together separated by a space.
e.g. C1 = 01302 820353
Furthermore I then need to prefix the C1 cell with a t: e.g.
C1 = t: 01302 820353
I hope that makes sense!
Thank you for looking and I hope someone can help.
Best wishes
Jon
:)
--
fuzzyjon
------------------------------------------------------------------------
fuzzyjon's Profile: http://www.excelforum.com/member.php...o&userid=34378
View this thread: http://www.excelforum.com/showthread...hreadid=541570
|