LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Delete first two characters in a cell... ChuckF Excel Worksheet Functions 6 September 5th 06 08:46 PM
Delete first few cell characters mohd21uk via OfficeKB.com Excel Discussion (Misc queries) 4 June 7th 06 12:32 PM
delete all the cell that contains more than 25 characters [email protected] Excel Discussion (Misc queries) 2 June 7th 06 12:06 PM
can i delete the last 3 characters in each cell in a column in 1 . homer Excel Discussion (Misc queries) 7 December 15th 05 02:51 AM
set up a macro to delete characters in each cell of a column Rick Excel Discussion (Misc queries) 2 September 18th 05 03:02 AM


All times are GMT +1. The time now is 10:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"