Microsoft excel help office for mac convert text to columns treat consecutive delimiters as one4/27/2023 I then right clicked on one of the "record" values and selected "drill down" and that converted it into data that I could then add to a table. I attempted to convert all of them into a table but it said it couldn't create a table with "record" values. So, when utilizing the From Text option, I ended up with a long list where all the values were classified as "Record". I utilized the From Text option, as the JSON files I have are downloaded as a zip file, so I didn't have a URL (I probably should have prefaced with the fact that this is my first time working This has been really helpful, and I had a tiny amount of success.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |