Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with formula
Hi All,
I wish to create a formula to be able to split a text string in a given place and copy one part to another cell and the other part to a different cell. Please let me explain.... I have a worksheet ranging from cell A1 to A6000 containing a list of all my MP3 files stored on my PC. The format of all the file names is for example Artist Name - Song Title eg: Madonna - Hung Up. I wist to take all characters before the space hyphen space and copy this to column B and all charachters after the space hyphen space and copy these to column C. This is what I should end up with: A1 B1 C1 Madonna - Hung Up Madonna Hung Up The text strings in cell A1 : A6000 are all varying lenghts and this is where I a struggeling to get a formula to work. I am using Excel version 2002 SP3 Many thanks Dave |