Any Excell Gurus in here?

[gsilbers]

i had to type up all my songs (160+) in an excell sheet but now i have to add the .wav extension. any ideas how besides doing it manually?

thanks

[tropicalhotdog]

you could deisgn a macro to do it, but frankly it'd be faster just to type ".wav" once, copy it, then go down the list hitting: Enter, F2, Control-V 160 times if you don't know how to do macros.

the macro would just do that for you, if you know how to do it. it's just way to automize repeated commands. not hard - the built-in tutorial will show you how.

[robertshaw]

=CONCATENATE(A1,".wav")

Then just drag south 160+


or add ".wav" to a column next to your song names copy/drag down 160+
export to .csv , open csv w/ notepad search/replace to remove the comma
then reimport csv into excel

there is also a way in excel to add a prefix or suffix
can't remember of the top of my head

[tropicalhotdog]

cool - didn't know that function
very useful!

[travtele615]

Originally Posted by robertshaw

=CONCATENATE(A1,".wav")

Then just drag south 160+

if you're not super familiar with excel and what "drag south" means. click on the cell containing the equation above lets say "B1". In the bottom right corner you'll see a small black square as part of the outline.

Hover over that and your cursor will change. click and drag down and it will repeat the equation updating the A1 to A2 to A3 etc.

The same technique is handy for dates. Type a date into first cell and then drag down and it will put in consecutive dates till you stop.

type 1 and 3 in cells A1 and A2. highlight both cells and drag and it will give you all the odd numbers. etc.