Merge text with hyphen "&" in Excel table

Source: Internet
Author: User

1, insert two empty columns after column D (E, F), and then enter the formula in cell D1: =b1&c1&d1.

2, select D1 cell again, use "fill handle" to copy the above formula to the cell below D column, the contents of B, C and D are merged into the corresponding cell of e column.

3, select the column e, perform a copy operation, then select the F column, perform the edit-paste Selective command, open the Paste Selective dialog box, select the value option, press the OK button, and the contents of the E column (not the formula) are copied to column F.

4, the B, C, D, e column Delete, complete the merger work.

Tip: Complete the 1th, 2 steps, the merge effect has been implemented, but if you delete the B, C, D columns, the formula will appear an error. Therefore, the 3rd step is required to convert the formula to the invariant "value".

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.