Forum Discussion
Formatting Feet and Inches in one cell
Hi all, I am working with a spreadsheet of archived baseball team rosters (each year's roster is contained as one sheet in the larger workbook). These were previously on paper, but are now being...
Thanks all, for your replies and insight. Some follow up info:
1. Thank you Riny for the tip on column formatting. I forgot about the apostrophe trick!
2. These paper rosters for a college baseball team (which go back as far as the 1970s) were typed by hand into a cloud-based Google spreadsheet, which I then downloaded as an XLS file. For a couple reasons we preferred hand-typing rather than an automated process.
3. Here is an example of how the rosters are presented once imported/ingested. Different school, but same website platform and CMS:
https://bryantbulldogs.com/sports/baseball/roster
Intent here by typing the paper rosters then importing, is to display historical team rosters (i.e. 1985) in the same way as the roster for 2024 team. With the exception of anything that might not be available on a year-to-year basis--for example, the paper version of our 1979 roster does not have jersey numbers.
4. XLS is preferred for importing format, but CSV also can work
After reading these replies I also went into the original Google spreadsheet and changed the height column formatting to plain text. The heights *appear* to be kept in their originally-typed format (such as 5-11). I will try importing a few rosters with this adjustment.
Thanks again everyone!
1. Thank you Riny for the tip on column formatting. I forgot about the apostrophe trick!
2. These paper rosters for a college baseball team (which go back as far as the 1970s) were typed by hand into a cloud-based Google spreadsheet, which I then downloaded as an XLS file. For a couple reasons we preferred hand-typing rather than an automated process.
3. Here is an example of how the rosters are presented once imported/ingested. Different school, but same website platform and CMS:
https://bryantbulldogs.com/sports/baseball/roster
Intent here by typing the paper rosters then importing, is to display historical team rosters (i.e. 1985) in the same way as the roster for 2024 team. With the exception of anything that might not be available on a year-to-year basis--for example, the paper version of our 1979 roster does not have jersey numbers.
4. XLS is preferred for importing format, but CSV also can work
After reading these replies I also went into the original Google spreadsheet and changed the height column formatting to plain text. The heights *appear* to be kept in their originally-typed format (such as 5-11). I will try importing a few rosters with this adjustment.
Thanks again everyone!
RyanGallant Well, I don't work with Google sheets, but if you can provide a link hat give access to the to a file, than it shouldn't be too difficult to transform it to an Excel file and, in turn, transform it to something you can use to upload to the web-site. Not sure though without seeing an example of a file.
