Anyone handy with Excel ?

[LilleyPadGifts]

I'm not really sure where to post this, but hoping someone that is VERY familular with Excel will see it here.

I am working on my Comic Store (1 of about 5-7 stores I'm creating for my village of shops).
I currently enter the comics into a online database (ComicBookRealm.com). I have roughly 30,000. I must use the db to verify by cover image sothat I get the correct info on the comic...I'm not a collector and only know what I've learned over the years since obtaining this large lot.
I can export files from CBRealm with no problem.
What I can't do is add more product fields AND use Easy Populate.
Is there a easy way to "merge" together fields in Excel so that I could take the info from the "merged" fields and in the Description field for EP so that I can THEN upload the file into EP??
Anybody get that?
I know there is a Merge feature in Excel, but it both fields have info it deletes one and keeps the upper left (I think) info only.

I'm open to suggestions!!!!! PLEASE have suggestions
Thanks so much,
Lalla

[misty]

TIP
Download and install Open Office...
Works much better with EP than Excel

[JJDoench]

The simple answer is YES! It is really pretty easy. The function you are looking for is Concatenate. Search your Excel help.

=CONCATENATE(A1,B1,C1)

I also put in <li> tags to create a formatted list from my extra fields. That's how I put together my image URLs for EP too.

There is another way to do it that I read about briefly, but concat works great for me.

Good luck,
Jessica
Best Friends Quilt Shoppe
www.bestfriendsquilts.com

[LilleyPadGifts]

The simple answer is YES! It is really pretty easy. The function you are looking for is Concatenate. Search your Excel help.

=CONCATENATE(A1,B1,C1)

I also put in <li> tags to create a formatted list from my extra fields. That's how I put together my image URLs for EP too.

There is another way to do it that I read about briefly, but concat works great for me.

Good luck,
Jessica
Best Friends Quilt Shoppe
www.bestfriendsquilts.com

Thank you so much!!!! this is what I was looking for but now I can't seem to get it to work. How to I add spaces between words? or add characters?
I'm on my notebook in bed sick at the moment so I'm having to use OpenOffice instead of Excel, but it has the same option. Just need to figure how to use it!

[LilleyPadGifts]

Ok, I think I figured it out.... I add a column with the spaces and, in this case, the # sign I want added and it works PERFECTLY!

But...now I have another problem. How do you get the info to stick while removing the columns no longer needed since the function comes from them? EP won't take the extra columns


Lalla

[danielson]

Copy the contents of the cells, then paste the content using Paste Special. Choose "values". Then paste it and the data will be pasted as the values and no longer as a fomula, so you can then delete any other cells you don't want and the values will stay the same.

As misty said, try Open Office instead. Its very good and its free!

http://www.openoffice.org/

[LilleyPadGifts]

Oh my gosh! Thank you so much for that info. You have saved me hours of work (and mistakes I'm sure)!!

I have one more Excel question....
Is it possible to
"remove all but the first letter in the field"?

I want to be able to take the same file and use the
v_products_name_1

remove all but the first letter in the field and have it then also become... v_categories_name_1
after adding the words By Title