var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: extract last word 4 multiple cells
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,