| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Concatenate two halves of a phone number
I'm trying to concatenate two halves of a phone number - dialling code in one
column and number in adjacent column. Concatenate doesn't work, nor does "&". Numbers are put in as numbers but recorded as text. Big file - 700K |
|
#2
|
|||
|
|||
|
Hi Harry
what happens when you type say in C3 =A1 & B1 or =CONCATENATE(A1,B1) Cheers JulieD "Harry Macdivitt" <Harry wrote in message ... I'm trying to concatenate two halves of a phone number - dialling code in one column and number in adjacent column. Concatenate doesn't work, nor does "&". Numbers are put in as numbers but recorded as text. Big file - 700K |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| Phone number formats | Excel Discussion (Misc queries) | |||
| Phone Dialer | Excel Discussion (Misc queries) | |||
| How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
| Convert week number into calendar month? | Excel Worksheet Functions | |||
Linear Mode
