copy cell to another cell with text

[CaptainMortgage]

I'm not really sure how to do this here. What I have is a spreadsheet with about 10,000 songs on it and I need to add a field with the month, and year of the cd and with the track number also. I have the track number in another column and what I'm trying to do is type in the month/year code e.g. JAN07- and then I want to put the track number after that. I'm trying to not press F2 10k times and then type the corresponding number in lol. Is there a way I can just type the text in JAN07-(=A1) or something like that. Also that - is a hyphen and not a minus sign. I hope this makes sense and that someone with a little more experience can help me out with this. I'm ususally pretty good with stuff like this but I'm completely stumped on this one.

Thx,
Joel

[mudraker]

you could use a formula
="JAN07 - " &A1

or you could use a worksheet change macro
The column Number & letter shown in Red will need to be changed to suit

'These instructions pre typed & are worded to cater for the novice programmer
'To install macro to correct location

'Copy this macro
'GoTo Excel
'Select sheet this is to appy to
'Right Click on Sheet Name Tab > select View Code
'Past macro into the Worksheet Module displayed

Please Login or Register  to view this content.

[CaptainMortgage]

That's exactly what I was looking for. Thank you so much for your help. I had to tweak it a little to get it to stop auto formatting the date, but I got it to work. I'm not as experienced as most people in regards to software or programming, but if you need any advice on Real Estate, Mortgage or Finance. I can help with that. Thanks again.