You are looking for more information about how to exclude members using "Paste from Clipboard" functionality in Analysis Office.
SAP BusinessObjects Analysis, edition for Microsoft Office
In order to exclude members using Paste from Clipboard functionality, an exclamation must be entered in front of the values.
Example for excluding a list of members: !1; !2; !3 (exlude the members 1, 2, 3).
Refer to chapter "To filter data by member" in User Guide.
2875396 - Exclude member by Paste from Clipboard not working for compounded characteristics
exclude, excluding, removing, exclamation, !=, range, pasting, clipboard, filter, filtering , KBA , BI-RA-AO-XLA , Excel Addin , How To
SAP Analysis for Microsoft Office all versions