Nov 28 2018 09:12 PM
Can someone please help advise me if it is possible to link a word in one cell with a dollar value in another cell. i have a fee sheet that i am wanting to merge in word and want to be able to enter a subject (column a) and have the fee(column B) for that subject to automatically pop up with it. i have been given data from two spreadsheets and am hoping i can merge the two.
thank you in advance.
Nov 29 2018 12:51 AM
if you need to add two strings in different cells you can use "&" operator or concatenate function (tehy both work the same way) for example
=Sheet1!A1 & Sheet2!B2
will combine values in sheet a1 cell and sheet b2 cell as a string in the cell this formula is written.