Need crash course in Excel 2003 - DPChallenge Forums

Nikon AF Zoom-Nikkor 24-85mm f2.8-4.0D

09/29/2007 08:51:20 PM · #1

Does anyone know a good book on Excel 2003?

I have a new hellish project at work.
I need to renovate the excel inventory pages we use at work and produce a database for the new website (in production). The web developer has given me the template. Many of the fields are repetitive
"11T15" "15" "T15"
"11T27" "27" "T27"

I want to merge the data in 2 columns, insert a few repetitive characters in front of some text, re arrange the sequence of columns...
I think it is all pretty standard, but I'm not quite getting it from the help files.

I work in a bead store and the site is going to have abut 15 or 20 different pages, each one 200-600 items. I really don't want to retype any more than I have to.

I am the only person in the building with any computer experience. So I have no back-up. Beginning to feel a little panicky. I'm dyslexic and really want to copy and paste and merge as much as possible.
The woman who started this project is no longer with the company, and wasn't very interested in sharing knoledge anyhow.

Any suggestions would be greatly appreciated

Thank you
Alice

Message edited by author 2007-09-29 20:53:33.

Nikolai1024

Nikon D300

09/29/2007 08:54:02 PM · #2

Easy. Email me XLS file and I'll put formulas in. Put a bit more details on how you want columns to look.
Nikolai1024 (at) yahoo . com

Nikon AF Zoom-Nikkor 24-85mm f2.8-4.0D

09/29/2007 08:56:40 PM · #3

Thanks, I will on Tuesday when I get back there.
I really appreciate it.
Alice

Message edited by author 2007-09-29 20:56:58.

Nikolai1024

Nikon D300

09/29/2007 08:57:56 PM · #4

Originally posted by BlueZamia:

Thanks, I will on tueeday when I get back there.
I really appreciate it.
Alice

Flying out for Keys GTG on Tuesday. Someone else may have to help you then.

Nikon AF-S DX NIKKOR 18-200mm f/3.5-5.6G ED VR II

09/29/2007 09:02:45 PM · #5

Thanks for the offer.
My plan was to get recommendation on a good text and learn the program. If I make this work the boss will ask me to do more, so I need to know it anyhow. Plan to have him pay for a class later.

Nikon D200

09/29/2007 09:53:02 PM · #6

It sounds like you might need a combination of the Concatenate function and the Left (or Right) function.

The key is to determine in advance the string length of your desired end point.

I can help you, and I'll be around on Tuesday. PM me for me detail.

09/29/2007 10:14:08 PM · #7

Thanks, I really appreciate it.

Alice

rex

Canon PowerShot SD780

09/29/2007 10:30:16 PM · #8

meanwhile a related story:

//www.wsbtv.com/technology/14227937/detail.html

I told you that answer was wrong!!!!!

To keep your thread on subject though. The Excel Bible is an excellent reference to have.

Message edited by author 2007-09-29 22:31:40.