Any Excel gurus in here?

Brian Farkas posted this at 04:45 — 23rd March 2001.

Joined: Apr 1999

Hello. I'm currently working with a client to import his database into some shopping cart software. One of the fields is the "image" field. Thankfully, he already has all the images ready, in the format of .jpg. We have a spreadsheet of all the other information we need except for this, and I was wondering if there was some sort of formula to take the data from the first column and add a .jpg onto the end of it...

For example, if the product number was AB123, we would want a formula or format option, etc. that we could input to get "ab123.jpg" in a different cell- if there is a way to make the new cell lowercase, that would be even better. Unfortunately, it wouldn't be feasible to do this manually since
we're talking about a DB with 1000+ products.

Does any one have any ideas? Thanks in advance for your help!

Brian Farkas

Brian Farkas posted this at 05:56 — 23rd March 2001.

They have: 1,015 posts

Joined: Apr 1999

Thanks anyway-
I got a reply from somebody else that explained how to do it... For future reference:

=LOWER(CONCATENATE(A2, ".jpg"))

Replace A2 with the starting cell

Thanks,
Brian

Mark Hensler posted this at 07:16 — 23rd March 2001.

He has: 4,048 posts

Joined: Aug 2000

Excel has a built in formula builder/helper thingy...

Type = in a cell, then look up near the top.
You should see a function in a dropdown menu on the far left (with a red X and a green checkmark to the right of it).
Click the down arrow, and select "More Functions..."
Now find the appropriate category on the left ("text" in this case), and find the function you need on the right.

"Give a man a fish, and he'll eat for a day. Teach a man how to fish, and he'll eat for a lifetime." - some wise guy

Mark Hensler
If there is no answer on Google, then there is no question.