=LEFT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2, "_", " "), ".", ""), "jpg", ""), LEN(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2, "_", " "), ".", ""), "jpg", "")) - 4)
Category
Abstract
Animals/Wildlife
Art
Backgrounds/Textures
Beauty/Fashion
Buildings/Landmarks
Business/Finance
Celebrities
Education
Food and drink
Healthcare/Medical
Holidays
Industrial
Interiors
Miscellaneous
Nature
Objects
Park/Outdoors
People
Religion
Science
Signs/Symbols
Sports/Recreation
Technology
Transportation
Vintage