We can add the text values according to our preferences either by using the CONCATENATE function in excel or ampersand. Open the Word. Use this syntax whenever you need to access an Excel function from a VBA module.
In the Formula dialog box.
Heres how to embed an Excel worksheet using the simple paste option. Type the plus sign into the formula after A3. Insert An Excel Worksheet As An Embedded Object. Use this syntax whenever you need to access an Excel function from a VBA module.