Wednesday, October 27, 2010

Excel - Remove Characters from end of string in cell

If you have a column A, and you want to create a column B with equivalent to A minus some characters at the end of the string (in this example one but you can increase -1 to however many characters you would like to use), put this into B1 and copy down.


No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...
Web Design & Marketing - Click and get an instant quote on your project