i need to just keep the last word of my cell for about 5000 cells.

i.e. Clothing:LSTP1000 i only need the LSTP1000

but i need to do this for 5000 cells, on all of them i need everything after the colon

Thank you for your help!

Welcome to the Board!

Here's a formula approach: =RIGHT(A1,LEN(A1)-FIND(":",A1))

Or faster would be to highlight the entire range and goto Data-->Text to Columns-->Delimited. Select "Other" and enter a Colon. It will parse your information into two seperate columns.

Hope that helps,

Smitty

EDIT: Typo