Anyone handy with Excel ?

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?? :wacko:
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 :cry:
Thanks so much:D,
Lalla

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

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
https://www.bestfriendsquilts.com

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

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! :smile:

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

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/

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

The get the first letter in a field simply use the model: LEFT(A1,1)

The extra columns for spaces and the hash character are unnecessary. You could simply use this model instead: CONCATONATE(A1," ",B1)

I posted a fairly detailed example of using CONCATENATE:

http://www.zen-cart.com/forum/showthread.php?t=117305

What I do is pretty similar to what fairestcape detailed in the thread referenced. Sorry I forgot to mention the Paste Special. That is pretty important.

Also, since we add new products on a regular basis, I set up various macros to do all the concatenating, adding/deleting columns, copying/pasting special, etc. It took a while of fiddling to get my macros to work exactly as I wanted them to, but they save me a ton of time now, and reduce mistakes.

I found out how to do all the stuff I did by searching the web, and reading the Excel help file. There are a lot of good Excel tutorials out there online.

I'm glad you were able to solve your problem!

Jessica
Best Friends Quilt Shoppe
https://www.bestfriendsquilts.com