Excel emerge two column into one

Here is excel form. I would like to emerge the column C and column D into column E. The format should be like E4 after emerging. Any expert can give me some suggestion to do it with fast way? thank you
Capture.PNG
EESkyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Glenn RayExcel VBA DeveloperCommented:
In cell E4 add this formula  and copy down:
=D4&C4

This is the shortcut method for the CONCATENATE function; the ampersand symbol (&) connects the two cell values together.

same as:
=CONCATENATE(D4,C4)

Regards,
-Glenn
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ProfessorJimJamCommented:
Glenn you are fast
0
Glenn RayExcel VBA DeveloperCommented:
You say that, but I didn't post until 28 minutes after the OP.
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

EESkyAuthor Commented:
Thank you so much for your fast reply. But it looks like the emerged data cannot be copied, right ?
0
Glenn RayExcel VBA DeveloperCommented:
Sure; you can copy the cells and paste the values elsewhere.

1) Select all the cells to copy
2) Press [Ctrl]+[C]
3) Select the cell where you want to paste.*
4) Menu:  Home tab, Paste (drop arrow), Paste Special.  
5) Select "Values" from the dialog box and click the "OK" button.
paste special - values

* If you want to replace the formulas with the values, just skip step 3.

Regards,
-Glenn
0
EESkyAuthor Commented:
Thank you for writing a lot. The real situation is a little more complex than the example i gave here. The real case should be like this:

as:dd=xgg&hh+x@uu--- all the column C is filled with as:dd=xgg&hh+x@uu. I would like to replace x in column C with column B. Since the colomn contain some special charaters, it cannot work. After replacing, each one should be like this
as:dd=expressgg&hh+express@uu
Capture.PNG
0
Glenn RayExcel VBA DeveloperCommented:
I'm pretty sure it can be made to work still, even with the special characters.

So, do you want to replace each occurrence of "x" in column C with the associated value in column B?  For example:
B13: express
C13: as:dd=xgg&hh+x@uu
D13: as:dd=expressgg&hh+express@uu  (temporary, to replace column C)

If this doesn't make sense, you may have to show some actual data.
0
EESkyAuthor Commented:
Great! Thank you.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.