npub1gajvsj4vhehzjtpq9sax45j49qa623vtl6fu6djjrjzm05w48l8srt78dz (npub1gaj…78dz) I tried doing this in Excel with the Upper function but I couldn't get it to work. I'm sure it was operator error and not an Excel issue. Here's a roundabout way to do it, though, which did work for me. Select the cells in the column that you want to convert or you can press ctrl+space to select the entire column.
Press ctrl+c to copy the cells into the clipboard.
Open a blank Word document and press ctrl+V to paste the cells.
Press ctrl+A to select all cells in the Word document.
Press shift+f3 repeatedly until your case changes to all caps.
Select all cells and copy them to the clipboard.
Go back to Excel, move to the beginning of the column where the capitalized text should be and paste.
I'm sure that this method is like going to China to get to California but it's easy and should work.
David Goldfield /
npub1tz…d3pcl
2024-01-19 23:31:45
in reply to nevent1q…0f58
Author Public Key
npub1tz5krh65n5lqp7dcfdk7c4wu4c0h4k88mlu46c9dtxjjdlmj3jcsfd3pclSeen on
wss://relay.nostr.bandPublished at
2024-01-19 23:31:45Event JSON
{
"id": "de297860ee794b1f79218f03f16131cd9b8313ef9775ac85b4bb3ce1a3dce7f0",
"pubkey": "58a961df549d3e00f9b84b6dec55dcae1f7ad8e7dff95d60ad59a526ff728cb1",
"created_at": 1705707105,
"kind": 1,
"tags": [
[
"p",
"4764c84aacbe6e292c202c3a6ad255283ba5458bfe93cd36521c85b7d1d53fcf",
"wss://relay.mostr.pub"
],
[
"p",
"e8a672ca9b1d456ad5063beda3ef127510ae3a7806049483e86c8518ac7edd36",
"wss://relay.mostr.pub"
],
[
"e",
"d73edcefca2cf2c8f6104b6db78c8929900b54104ebde108d4b1a9aec7fe4815",
"wss://relay.mostr.pub",
"reply"
],
[
"proxy",
"https://tweesecake.social/users/DavidGoldfield/statuses/111785220864027203",
"activitypub"
]
],
"content": "nostr:npub1gajvsj4vhehzjtpq9sax45j49qa623vtl6fu6djjrjzm05w48l8srt78dz I tried doing this in Excel with the Upper function but I couldn't get it to work. I'm sure it was operator error and not an Excel issue. Here's a roundabout way to do it, though, which did work for me. Select the cells in the column that you want to convert or you can press ctrl+space to select the entire column.\nPress ctrl+c to copy the cells into the clipboard.\nOpen a blank Word document and press ctrl+V to paste the cells.\nPress ctrl+A to select all cells in the Word document.\nPress shift+f3 repeatedly until your case changes to all caps.\nSelect all cells and copy them to the clipboard.\nGo back to Excel, move to the beginning of the column where the capitalized text should be and paste.\nI'm sure that this method is like going to China to get to California but it's easy and should work.",
"sig": "0fa5ca614df9297372c0b8261f07d39374ab0c85ba7d6a442bc721c3284cd4a0601f7a7a98d0b4f9cfb56f8ca983d5cdcf12d229b848123c549d6270f588e240"
}