hey guys, i copy the info from my credit card statement into Excel. the way it copies into Excel is that the merchants' names and the prices i paid are all in one cell. currently, i manually "cut" the prices and put them in another column so that the end result is two columns, one with the merchant's name and another with the price. i would like to automate this using VBA... here is the psudocode: 1) the right-most information in the cell is always the price so read the characters from right to left 2) while reading the characters, copy them until you get to a character that's not a number 3) paste the copied characters (which should all be numbers) in the next column's cell. does anyone know how to write that in VBA code? thanks!