May 24 2018
08:42 AM
- last edited on
Jul 31 2018
08:15 AM
by
TechCommunityAP
May 24 2018
08:42 AM
- last edited on
Jul 31 2018
08:15 AM
by
TechCommunityAP
I need the two columns to be the product model and the manufacturer combined. I have a column with the Manufacturer and a column with the Product Model.
Product Model must be entered in the format "Model (Manufacturer)"
examples.... XYZ 23 (Sony)............. Series 123 (Apple)
May 24 2018 09:28 AM
You can use the Concatenate Function or the & Operator
like follows:
=B2&A2
=B2&" ("&A2&")"
=CONCATENATE(B2,A2)
=CONCATENATE(B2," (",A2,")")
Please see example file.
May 24 2018 09:48 AM
Lenovo | M800 | =H2&" ("&G2&")" |
Thanks so much!!
This is what I have -- now what do I do to make the words appear there and in the rows below?
Vanessa
May 24 2018 10:04 AM - edited May 24 2018 10:06 AM
If the formula is actually showing in the cell you need to change the cell format from TEXT to General and then confirm the formula again by putting the cursor in the cell and pressing enter. If it's already a formula then you can just do the following.
You can use the autofill functionality as shown below:
May 24 2018 01:00 PM
Thanks for our help!!
Vanessa
May 24 2018 01:48 PM
Vanessa-
You're quite welcome. Please feel free to post back to the community if you have any additional questions. Always happy to help!
Oct 25 2021 03:06 AM
Thanks Its real work@Matt Mickle