|I knew there had to be a way to make the spaces stay, but my boyfriend was complaining about me still being up at 4am....|
name genus scientific name rarity season location details locations found
Abyssal Phanto phanto abyss very rare N/A fissures fissures
Abominal chiro chiro monstus Legendary rare winter 2010 holiday forest holiday forest
That's what I want it to look like, and there's probably 1000+ entries like those 2 (it was worse before I removed all the other crap from the text with text mechanic... this project mean I have to copy from a website 10 entries like those per page with pics and other stuff and then clean that up, and there are I think at least 100 pages!) Yes some have a 'season' field and some don't, and yes I need that field... well, maybe I could live without it - I'm already thinking of skipping the 'scientific name' field, I could probably do without the season for now since I'm mostly just wanting a checklist. Go ahead and pretend the 'season' line isn't in my data. And please be very clear in how to do what you suggest, I know practically nothing about excel except how to open cvs(?) files. If you can't help I'll probably just use Just Basic to write a little program to change the data to cvs(?) format - if line includes locations found then print line and then new line else print line and add a comma. That should put all of each pet into a separate line with commas between each field.... It's just with having to copy so much to text mechanic and all that, I really don't want to have to run it through another step before the spreadsheet.
Ayways I'm rambling..... if you can help I appreciate it
Oh yeah, if you could explain how the formula's etc that you suggest work that would be much appreciated (then maybe next time I can figure it out myself lol)