ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   in excel , arrange scrip names alphabatically (https://www.excelbanter.com/excel-discussion-misc-queries/206025-excel-arrange-scrip-names-alphabatically.html)

logu

in excel , arrange scrip names alphabatically
 
In MS Excel, a column has scrip names at randum. Is there any provision to
arrange them alphabatically??

Mike H

in excel , arrange scrip names alphabatically
 
hi,

You may have to remind me what a 'scrip' name is but have you tried

Data|Sort

Mike

"logu" wrote:

In MS Excel, a column has scrip names at randum. Is there any provision to
arrange them alphabatically??


Bernard Liengme

in excel , arrange scrip names alphabatically
 
Have you looked at the menu command Data | Sort?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"logu" wrote in message
...
In MS Excel, a column has scrip names at randum. Is there any provision to
arrange them alphabatically??




Earl Kiosterud

in excel , arrange scrip names alphabatically
 
Logu,

Mike and Bernard have suggested the sort function. If these "scrip names" are in a
worksheet, it's exactly what you need. If there are other columns associated with this
column (so it's really a table) that should also be sorted, be sure you sort properly.
Excel can ruin a table if you're not careful. For more on sorting, read "Sorting in Excel"
at http://www.smokeylake.com/excel/excel_truths.htm

--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"logu" wrote in message
...
In MS Excel, a column has scrip names at randum. Is there any provision to
arrange them alphabatically??





All times are GMT +1. The time now is 02:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com