Copying the contents from Excel into a text file won’t work. Try exporting the file from Excel as TSV (Tab-Separated Values, .tsv file extension). There’s resources online that’ll show you how to do this in Excel, e.g. this page.
It looks like you’re creating a QIIME 1-style metadata file, where the header is a comment line (i.e. starts with #). As described in the metadata file format spec, if you’re using a QIIME 1-style file, the header must start with #SampleID. Note that in your file, you have an extra space in the name: #Sample ID.
You have a couple of options:
Rename the first cell to #SampleID (i.e. remove the space).
Remove the # character from the first cell (then you can name the cell whatever you want).
If that doesn’t work, please attach the TSV metadata file you’re using, and include the exact command and error message you’re receiving. Thanks!