How do I creat a macro to delete the first 20 cell characters
I have a spreadsheet that has a column containing date, time and other info I
don't need. (Ex: 12/13/2006 01:07 PM 3,695,666 Travis Tritt). Its a
musical listing imported from a directory. I want to delete everything
except for the final text (from the example "Travis Tritt"). The spacing is
the same for every cell. I want to copy the contents to another column, then
delete the first x number of characters so that only the text remains. I
tried to create a macro to do this but have failed. How would I set up a
macro to do this so that it is relative to each cell. Or, is there an @
function that would do this??
Thanks
|