separation

Example is below. Which was pasted from a word doc copy. If I post the copied text in gmail, it does the separation! But if I try to post the list in excel, it puts all the content into one cell. Maybe there is some prepasting setup I can do in excel before pasting that would do the...

Team, I'm working with "Net Periods of Service" and need a formula that converts days into months and years, and/or months into years. For instance, this is what I have: Note: Using MS Excel 2016 (MAC Version) Net Active this period...

Hello, Below is an example of the data I am working with: <tbody> =LEFT(B2,2) Full Location ID Units A0 A010101A 74517894 10 D0 D010102A 74517894 100 GD GD10103A 96441511 50 RE RE10101A 74517894 100 RE RE10102A 87456430 144 RE RE10103A 74517894 100 </tbody> Here is the output I...

Hi I have this sheet (please see the link below) and I want to separate them into columns. Text-To-Column did not do the right job. Is there anyway to do clean separation in case like this. Thanks a lot. https://docs.google.com/spreadsheets/d/11opqWXTJ1-N2-yFID7yjMWjnJCNO85nV/edit?usp=sharing

I have a WB where column A contains stocks and stock symbols. The stock symbols represent the last 1-4 letters in each cell. Because each stock name (and symbol) is of different length and may or may not have multiple spaces, the traditional means of "reverse contatenation" aren't helping (e.g...