Many membrane-active peptides, such as cationic cell-penetrating peptides (CPPs) and antimicrobial peptides (AMPs), conduct their biological functions by interacting with the cell membrane. The interactions of charged residues with lipids and water facilitate membrane insertion, translocation or disruption of these highly hydrophobic species. In this review, we will summarize high-resolution structural and dynamic findings towards the understanding of the structure-activity relationship of lipid membrane-bound CPPs and AMPs, as examples of the current development of solid-state NMR (SSNMR) techniques for studying membrane peptides. We will present the most recent atomic-resolution structure of the guanidinium-phosphate complex, as constrained from experimentally measured site-specific distances. These SSNMR results will be valuable specifically for understanding the intracellular translocation pathway of CPPs and antimicrobial mechanism of AMPs, and more generally broaden our insight into how cationic macromolecules interact with and cross the lipid membrane.