Shutterstock Content Upload

=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