NEWBIE question

M

Missy

I have a worksheet and I need to ALPHABATIZE this list of names. It was
already done, but I had to delete some names and add others. Is there an
easy way to do this without having to retype all of these? Sorry if this
question seems silly but I have no idea how to use excel. This worksheet
was already done and given to me.

Thanks,

Missy
 
F

Frank Kabel

Hi Missy
you can try the following:
1. Add a helper column adjacent to your text column (assumption: A is
your text column and B your helper column)
2. In B1 insert the following formula:
=UPPER(A1)
copy this down for all rows
3. Highlich column B and copy the date
4. Select column A and goto 'Insert - Paste Special' Select 'Value' and
insert the names

Note: save your worksheet before doing this :)
Frank
 
G

Guest

Missy,
Frank's reply gives instructions on how to CAPITALIZE your list. Have you tried to use "Sort" under "Data" on the pull down menu?

Regards,
Mark Graesser
(e-mail address removed)

----- Frank Kabel wrote: -----

Hi Missy
you can try the following:
1. Add a helper column adjacent to your text column (assumption: A is
your text column and B your helper column)
2. In B1 insert the following formula:
=UPPER(A1)
copy this down for all rows
3. Highlich column B and copy the date
4. Select column A and goto 'Insert - Paste Special' Select 'Value' and
insert the names

Note: save your worksheet before doing this :)
Frank
 
M

Missy

I have now that my sister suggested it. Thanks Mark. I know I am slow as I
am not accustomed to this program.

Thanks again!

Missy

Mark Graesser said:
Missy,
Frank's reply gives instructions on how to CAPITALIZE your list. Have you
Click to expand...
tried to use "Sort" under "Data" on the pull down menu?
 
G

Guest

Missy,
Glad to here you got what you needed. Thanks for the feedback.

Regards,
Mark Graesser

----- Missy wrote: -----

I have now that my sister suggested it. Thanks Mark. I know I am slow as I
am not accustomed to this program.

Thanks again!

Missy

Mark Graesser said:
Missy,
Frank's reply gives instructions on how to CAPITALIZE your list. Have you
Click to expand...
tried to use "Sort" under "Data" on the pull down menu?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting multiple memberships 1
newbie ? 1
Combo-Box list unsorting 3
Creating a macro that simulates some of the toolbar button 1
VBA - retrieve data on last create named range from previous inserted named range 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Newbie Question... 6
Combining data from several worksheets 4

Top