Hi I was hoping to use the =Left function but also delete the characters that are being copied into the new cell.
So something like this: http://i.imgur.com/2Nvzs.png
I know how to do the first row labeled 1 but I need to do the second row labeled 2.
Bookmarks