General discussion

Locked

Combining Data from 3 cells in Excel

By loydster ·
This is in Excel 97, but I don't think it matters too much. I have about 6000 phone numbers in an excel worksheet. This is 6000 rows, by 3 columns. One column for Area code, one for exchange, and one for number. I need to combine this into one column. (Obviously, I will still have 6000 rows.)
It is date from an old mainframe, so the number was broken into 3 fields.
Thanks

This conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Combining Data from 3 cells in Excel

by Don Christner In reply to Combining Data from 3 cel ...

You can use the concantenate function or just use the & symbol. If the columns are numbers you need to change them into strings. If they are text in the next column just type =a1&b1&c1 and hit enter. Drag the formula down the column.

If they are numbers, in the next column type =str(a1)&str(b1)&str(c1).

Don

Collapse -

Combining Data from 3 cells in Excel

by Don Christner In reply to Combining Data from 3 cel ...

OOPS, the function is not str it's text.

Collapse -

Combining Data from 3 cells in Excel

by loydster In reply to Combining Data from 3 cel ...
Collapse -

Combining Data from 3 cells in Excel

by Frederick Bauer In reply to Combining Data from 3 cel ...

Here is something to try insert a new field after your three fields.
Example
A=area code
B=exchange
c=number
Make column D use the concatenate formula
=CONCATENATE(A2,B2,C2)

or use this for formated fields with dashes
=CONCATENATE(A1,"-",B1,"-",C1)

Then if you need you can insert a Col E and copy D and paste special in Col E by right clicking the selecting values when you paste. Then you could remove colums a thru d and have a formated phone number field.

Any questions please e-mail me!

Collapse -

Combining Data from 3 cells in Excel

by loydster In reply to Combining Data from 3 cel ...
Collapse -

Combining Data from 3 cells in Excel

by loydster In reply to Combining Data from 3 cel ...

This question was closed by the author

Back to Software Forum
6 total posts (Page 1 of 1)  

Related Discussions

Related Forums