Embed Notice

HTML Code

<blockquote style="position: relative; padding-left: 55px;"><section><a href="https://cosocial.ca/users/evan/statuses/110133299733842389">Evan Prodromou (evan@cosocial.ca)'s status on Monday, 03-Apr-2023 15:09:58 JST</a><a href="https://cosocial.ca/@evan" title="evan@cosocial.ca"><img src="https://gnusocial.jp/avatar/77066-48-20240924220431.webp" width="48" height="48" alt="Evan Prodromou" style="position: absolute; left: 0; top: 0;">Evan Prodromou</a></section><article><p>I needed some help with Excel. ChatGPT gave me step-by-step instructions. They worked great!</p></article><footer><a rel="bookmark" href="https://gnusocial.jp/conversation/1367746#notice-2822992">In conversation</a><time datetime="2023-04-03T15:09:58+09:00" title="Monday, 03-Apr-2023 15:09:58 JST">Monday, 03-Apr-2023 15:09:58 JST</time> <span>from <span><a href="https://cosocial.ca/@evan/110133299733842389" rel="external" title="Sent from cosocial.ca via ActivityPub">cosocial.ca</a></span></span><a href="https://cosocial.ca/@evan/110133299733842389">permalink</a><h4>Attachments</h4><ol><li><label><a rel="external" href="https://gnusocial.jp/attachment/846580">Evan: 1 have abig string of ike 25 words separated by semicolons. | want to make theminto rows in an Office 365 excel workbook.ChatGPT: To convert a string of words separated by semicolons into rows in an Office 365 Excel &amp; P workbook, follow these steps:1. Open a new Excel workbook.2. Click on cell AT (the first cell in the top-left corner).3. Paste your string of words separated by semicolons into cell A.4. Click on the 'Data’ tab in the Excel ribbon.5. Select cell AT again to make sure it's still selected.6. In the 'Data’ tab, click on the Text to Columns' button.7. In the 'Convert Text to Columns Wizard" that appears, select ‘Delimited" and click Next'8. In the 'Delimiters' section, uncheck any pre-selected options (such as Tab or Comma) and check the 'Semicolon’ option. You should see a preview of how your data will be splitin the 'Data preview" section. Click 'Next'9. In the 'Column data format' section, select ‘General’ (or the appropriate format for your data) and click 'Finish"10. Your string of words should now be split into separate cells in column A.11. Select all the cells in column A containing the split words. You can do this by clicking on the first cell (A1), holding down the 'Shift’ key, and clicking on the last cell with data.12. Press ‘Ctrl' + 'C' to copy the selected cells.13. Right-click on cell A1 and select 'Paste Special’ from the context menu.</a></label><br><a href="https://cosocial.ca/system/media_attachments/files/110/133/290/137/630/333/original/f6bd1cec0a5cc064.png" rel="external">https://cosocial.ca/system/media_attachments/files/110/133/290/137/630/333/original/f6bd1cec0a5cc064.png</a></li></ol></footer></blockquote>

Corresponding Notice

Embed this notice
Evan Prodromou (evan@cosocial.ca)'s status on Monday, 03-Apr-2023 15:09:58 JST Evan Prodromou
I needed some help with Excel. ChatGPT gave me step-by-step instructions. They worked great!
In conversationMonday, 03-Apr-2023 15:09:58 JST from cosocial.capermalink
Attachments
1. Evan: 1 have abig string of ike 25 words separated by semicolons. | want to make theminto rows in an Office 365 excel workbook. ChatGPT: To convert a string of words separated by semicolons into rows in an Office 365 Excel & P workbook, follow these steps: 1. Open a new Excel workbook. 2. Click on cell AT (the first cell in the top-left corner). 3. Paste your string of words separated by semicolons into cell A. 4. Click on the 'Data’ tab in the Excel ribbon. 5. Select cell AT again to make sure it's still selected. 6. In the 'Data’ tab, click on the Text to Columns' button. 7. In the 'Convert Text to Columns Wizard" that appears, select ‘Delimited" and click Next' 8. In the 'Delimiters' section, uncheck any pre-selected options (such as Tab or Comma) and check the 'Semicolon’ option. You should see a preview of how your data will be splitin the 'Data preview" section. Click 'Next' 9. In the 'Column data format' section, select ‘General’ (or the appropriate format for your data) and click 'Finish" 10. Your string of words should now be split into separate cells in column A. 11. Select all the cells in column A containing the split words. You can do this by clicking on the first cell (A1), holding down the 'Shift’ key, and clicking on the last cell with data. 12. Press ‘Ctrl' + 'C' to copy the selected cells. 13. Right-click on cell A1 and select 'Paste Special’ from the context menu.
  https://cosocial.ca/system/media_attachments/files/110/133/290/137/630/333/original/f6bd1cec0a5cc064.png

Public

Embed Notice

HTML Code

Corresponding Notice