Excel: Using string functions to reformat data

  • Event: 2019 CAR Conference
  • Speaker: Rachel Alexander of Salem Reporter
  • Date/Time: Thursday, Mar. 7 at 3:30pm
  • Location: Diamond Cove - conference level
  • Audio file: No audio file available.

Maybe you converted a PDF or imported a table into Excel -- or maybe an agency gave you a poorly formatted file. You can use string functions to reformat your data and get your spreadsheets working for you.

This session is good for: Anyone comfortable with using formulas in Excel.

Speaker Bios

  • Rachel Alexander covers education and nonprofits for Salem Reporter, an online news site in Oregon's capital. She's used spreadsheets to report on everything from nurses dying of opioid overdoses to roadkill salvaging on the state's highways. She's passionate about machine-readable document formats, crashing Excel with massive spreadsheets and #FOIAFriday. @rachelwalexande

Related Tipsheets

No tipsheets have yet been uploaded for this event.