Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Delete first two characters in a cell... | Excel Worksheet Functions | |||
Delete first few cell characters | Excel Discussion (Misc queries) | |||
delete all the cell that contains more than 25 characters | Excel Discussion (Misc queries) | |||
can i delete the last 3 characters in each cell in a column in 1 . | Excel Discussion (Misc queries) | |||
set up a macro to delete characters in each cell of a column | Excel Discussion (Misc queries) |