How to Paste YAML .txt code into excel and retain formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-1711965%22%20slang%3D%22en-US%22%3EHow%20to%20Paste%20YAML%20.txt%20code%20into%20excel%20and%20retain%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1711965%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20not%20surprised%20nothing%20matched%20my%20subject.%20And%20that%20would%20be%20why%20I%20am%20posting%20for%20help.%3C%2FP%3E%3CP%3EI%20have%20used%20Excel%20with%20editing%20JSON%20.txt%20file%20code%20before.%20I%20simply%20Copy%2F%20Pasted%20that%20code%20text%20into%20an%20Excel%20Column.%20Then%20made%20my%20edit%20changes%20to%20Copy%2F%20Pasted%20it%20back%20into%20NotePad%2B%2B%20to%20clean%20out%20the%20Excel%20format%20before%20uploading%20it%20back%20into%20my%20game%20file.%3CBR%20%2F%3EHowever%2C%20when%20I%20try%20to%20Paste%20my%20YAML%20code%20into%20a%20Column%20in%20Excel%2C%20Excel%20adds%20%3D%20sign%20just%20before%20the%20minus%20sign%20%3D-%20Text%20line%20and%20eliminates%20the%202%20space%20between%20the%20-%20minus%20signs%20to%20the%20number%20Coords%3A%20and%20cuts%20off%20the%20last%20few%20numbers%20to%20my%20coordinates%20after%20the%2015th%20decimal%20place.%3C%2FP%3E%3CP%3E%3CSTRONG%3EEXAMPLE%20YAML%20COPY%20TEXT%20TO%20PASTE%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E---%3C%2FP%3E%3CP%3Ename%3A%20Simon%20Templer's%20Kadish%20Quest%3C%2FP%3E%3CP%3Emarkers%3A%3C%2FP%3E%3CP%3E-%20text%3A%204%20letter%20name%20with%20a%20dash%20in%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%20age%3A%20Kadish%3C%2FP%3E%3CP%3E%26nbsp%3B%20coords%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%20-%2068.81651306152344%3C%2FP%3E%3CP%3E%26nbsp%3B%20-%20174.77679443359375%3C%2FP%3E%3CP%3E%26nbsp%3B%20-%200.44860178232192993%3C%2FP%3E%3CP%3E-%20text%3A%20I%20was%20wandering%20through%20the%20cavern%20city%3C%2FP%3E%3CP%3E%26nbsp%3B%20age%3A%20Kadish%3C%2FP%3E%3CP%3E%26nbsp%3B%20coords%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%20-%2056.62507629394531%3C%2FP%3E%3CP%3E%26nbsp%3B%20-%20188.29901123046875%3C%2FP%3E%3CP%3E%26nbsp%3B%20-%2016.009910583496094%3C%2FP%3E%3CP%3E-%20text%3A%20and%20ran%20into%20a%20player%20named%20%3F%20%3F%3F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%20age%3A%20Kadish%3C%2FP%3E%3CP%3E%26nbsp%3B%20coords%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%20-%20167.31703186035156%3C%2FP%3E%3CP%3E%26nbsp%3B%20-%20230.59422302246094%3C%2FP%3E%3CP%3E%26nbsp%3B%20-%2017.10062026977539%3C%2FP%3E%3CP%3E%3CSTRONG%3EEXAMPLE%20EXCEL%20PASTE%20IN%20RESULTS%3C%2FSTRONG%3E%3C%2FP%3E%3CTABLE%20width%3D%22296%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22296%22%3E%3CP%3E%3CFONT%20size%3D%222%22%3E---%3C%2FFONT%3E%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22296%22%3E%3CP%3E%3CFONT%20size%3D%222%22%3Ename%3A%20Simon%20Templer's%20Kadish%20Quest%3C%2FFONT%3E%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22296%22%3E%3CP%3E%3CFONT%20size%3D%222%22%3Emarkers%3A%3C%2FFONT%3E%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22296%22%3E%3CP%3E%3CFONT%20size%3D%222%22%3E%3D-%20text%3A%204%20letter%20name%20with%20a%20dash%20in%20it.%3C%2FFONT%3E%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22296%22%3E%3CP%3E%3CFONT%20size%3D%222%22%3E%26nbsp%3B%20age%3A%20Kadish%3C%2FFONT%3E%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22296%22%3E%3CP%3E%3CFONT%20size%3D%222%22%3E%26nbsp%3B%20coords%3A%3C%2FFONT%3E%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22296%22%3E%3CP%3E%3CFONT%20size%3D%222%22%3E-68.8165130615234%3C%2FFONT%3E%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22296%22%3E%3CP%3E%3CFONT%20size%3D%222%22%3E-174.776794433593%3C%2FFONT%3E%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22296%22%3E%3CP%3E%3CFONT%20size%3D%222%22%3E-0.448601782321929%3C%2FFONT%3E%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22296%22%3E%3CP%3E%3CFONT%20size%3D%222%22%3E%3D-%20text%3A%20I%20was%20wandering%20through%20the%20cavern%20city%3C%2FFONT%3E%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22296%22%3E%3CP%3E%3CFONT%20size%3D%222%22%3E%26nbsp%3B%20age%3A%20Kadish%3C%2FFONT%3E%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22296%22%3E%3CP%3E%3CFONT%20size%3D%222%22%3E%26nbsp%3B%20coords%3A%3C%2FFONT%3E%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22296%22%3E%3CP%3E%3CFONT%20size%3D%222%22%3E-56.6250762939453%3C%2FFONT%3E%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22296%22%3E%3CP%3E%3CFONT%20size%3D%222%22%3E-188.299011230468%3C%2FFONT%3E%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22296%22%3E%3CP%3E%3CFONT%20size%3D%222%22%3E-16.009910583496%3C%2FFONT%3E%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22296%22%3E%3CP%3E%3CFONT%20size%3D%222%22%3E%3D-%20text%3A%20and%20ran%20into%20a%20player%20named%20%3F%20%3F%3F%3F%3C%2FFONT%3E%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22296%22%3E%3CP%3E%3CFONT%20size%3D%222%22%3E%26nbsp%3B%20age%3A%20Kadish%3C%2FFONT%3E%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22296%22%3E%3CP%3E%3CFONT%20size%3D%222%22%3E%26nbsp%3B%20coords%3A%3C%2FFONT%3E%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22296%22%3E%3CP%3E%3CFONT%20size%3D%222%22%3E-167.317031860351%3C%2FFONT%3E%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22296%22%3E%3CP%3E%3CFONT%20size%3D%222%22%3E-230.59422302246%3C%2FFONT%3E%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22296%22%3E%3CP%3E%3CFONT%20size%3D%222%22%3E-17.1006202697753%3C%2FFONT%3E%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20searched%20in%20HELP%20and%20can't%20figure%20it%20out.%20Tried%20cell%20formatting%20for%20a%20number%20by%20setting%20the%20number%20decimal%20places%20to%2018%20to%20extend%20the%20numbers%20to%20show%20all%20them.%20Didn't%20work.%20No%20idea%20why.%3CBR%20%2F%3ETried%20turning%20off%20formula%20formatting.%20Nope.%26nbsp%3B%20Special%20Paste%20to%20keep%20Text%20formatting.%20Nope!%3C%2FP%3E%3CP%3ETried%20too%20many%20thing%20to%20list%20them%20all%20out%20here.%20I'm%20stumped%20and%20need%20expert%20help.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1711965%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I'm not surprised nothing matched my subject. And that would be why I am posting for help.

I have used Excel with editing JSON .txt file code before. I simply Copy/ Pasted that code text into an Excel Column. Then made my edit changes to Copy/ Pasted it back into NotePad++ to clean out the Excel format before uploading it back into my game file.
However, when I try to Paste my YAML code into a Column in Excel, Excel adds = sign just before the minus sign =- Text line and eliminates the 2 space between the - minus signs to the number Coords: and cuts off the last few numbers to my coordinates after the 15th decimal place.

EXAMPLE YAML COPY TEXT TO PASTE

---

name: Simon Templer's Kadish Quest

markers:

- text: 4 letter name with a dash in it.

  age: Kadish

  coords:

  - 68.81651306152344

  - 174.77679443359375

  - 0.44860178232192993

- text: I was wandering through the cavern city

  age: Kadish

  coords:

  - 56.62507629394531

  - 188.29901123046875

  - 16.009910583496094

- text: and ran into a player named ? ???

  age: Kadish

  coords:

  - 167.31703186035156

  - 230.59422302246094

  - 17.10062026977539

EXAMPLE EXCEL PASTE IN RESULTS

---

name: Simon Templer's Kadish Quest

markers:

=- text: 4 letter name with a dash in it.

  age: Kadish

  coords:

-68.8165130615234

-174.776794433593

-0.448601782321929

=- text: I was wandering through the cavern city

  age: Kadish

  coords:

-56.6250762939453

-188.299011230468

-16.009910583496

=- text: and ran into a player named ? ???

  age: Kadish

  coords:

-167.317031860351

-230.59422302246

-17.1006202697753

 

I have searched in HELP and can't figure it out. Tried cell formatting for a number by setting the number decimal places to 18 to extend the numbers to show all them. Didn't work. No idea why.
Tried turning off formula formatting. Nope.  Special Paste to keep Text formatting. Nope!

Tried too many thing to list them all out here. I'm stumped and need expert help.  

0 Replies