How to integrate data on Excel

Asked By 50 points N/A Posted on -
qa-featured

Hi expert,

I am faced with a problem with Microsoft Excel. I have a worksheet which includes details in 3 columns as follows.

Column A – Provincial code         Eg:   050

Column B – city code                      Eg:   4550

Column C – root code                    Eg:   9090

I want to take these three codes into one column (Column D) with a dash in between as follows.

050-4550-9090

Could you please explain me an easy way to do this by using an excel function or formula. 

Thanks.

SHARE
Answered By 0 points N/A #133709

How to integrate data on Excel

qa-featured

In Microsoft excel it is easily can be done your work. I will explain it through an example. I will take your data as follows.

You are able to take your required answer by using “&”.

First of all, the entire column D should be in General format.

In order to make it General, Select the column D, right click and click on format cells.

Format Cells

Then select the General option and click ok.

Format Cells

Then in cell D2 type the following formula and enter.

=A2&"-"&B2&"-"&C2

Formula in Excel

Now you can see that your required code is appeared in cell D2.

Formula Excel

Then copy that formula to below the cells. Then you will get all the codes as follows.

Formula for Cells

Login/Register to Answer

Related Questions