Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 170
  • Last Modified:

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
0
EESky
Asked:
EESky
  • 4
  • 3
2 Solutions
 
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
 
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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now