How to use the CONCATENATE function to link text in two columns
Requirement:
The user hs two columns with text and want to link them in a third coloumn.
i.e
Colomn A = 51645AE
Colomn B = HP Orginal Toner Cartrridge
Colomn C = 51645AE - HP Orginal Toner Cartridge
Solution:
In column C (for row 1) enter:
=A1 & " - " & B1
Using the CONCATENATE function instead would be equivalent.
=CONCATENATE(A1," - ",B1)
Obtained from the OzGrid Help Forum.
Solution provided by tomach.
See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets
See also:
| How to use IF function for time calculation |
| How to create a custom function to extract integers from a simple 11 character string |
| How to use cell content as input to a structured reference as part of a lookup function |
| How to use VBAs Find Function |
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.
Gallery
