How do I creat a macro to delete the first 20 cell characters

B

Bobo-ack

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
 
B

Barb Reinhardt

Select the column in question and Use Data -> Text to Columns -> CHoose fixed
width and NEXT. You can move the breaks or double click on them to remove
them.

HTH,
Barb Reinhardt

:th
 
P

Pete_UK

If the spacing is the same for each cell, then you can use the RIGHT
function, as follows:

=RIGHT(A1,LEN(A1)-32)

as I think you have 32 characters before the first "T".

This assumes your data starts in A1 - copy this down the column for as
many entries as you have in column A.

Hope this helps.

Pete
 
Top