var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Removing the last 4 characters from each column
I have 3000 rows excel spreadsheet that looks something like
45678.dwg... (continues on)
What I want to do is somehow remove the last 4 characters from each entry. Therefore remove the ".dwg" part from each entry. Any ideas?
=Left(<Value>, Len(<Value>) - 4)
How and where do I input that though?
In a new column?
I got it to work... thnx