Join Strings | Left | Right | Mid | Len | Find | Substitute. Excel has many functions to offer when it comes to manipulating text strings. To join strings, use the & operator. Note: to insert a space, use  . To extract the leftmost characters from a string, use the LEFT function. To extract the rightmost characters from a string, use the RIGHT function. To extract a substring, starting in the middle of a string, use the MID function. Note: started at position 5 (p) with length 3. To get the length of a string, use the LEN function. Note: space (position 8) included! To find the position of a substring in a string, use the FIND function. Note: string am found at position 3. To replace existing text with new text in a string, use the SUBSTITUTE function.
XOXO means âhugs and kissesâ but why? What's the reasoning behind abbreviating hugs and kisses as X's and O's? Some say X is for hugs and O is for kisses, and some say the other way around; but why X and O, and why are they doubled? In my experience 'X' for kiss is universal.
From this, at least we know the âXâsâ meaning âkissesâ preceded âOâsâ as âhugsâ as there are no such references up to this time of the latter, so thatâs something I guess.If you werenât satisfied with the lack of definitiveness of the âXâ part of things, youâll be even less so with the âOâ symbolizing the hug.e canât be 100% sure why or how XOXO ultimately came to mean âhugs and kissesâ, but we do at least have a reasonably good theory to work with on the âXâ part. Signing letters with an âXâ dates back to the Middle Ages.