| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing from format style to list style
I have a group of names that are in form format and want to change them to
list format. Once i used the formula on the first name is there a way to apply it to the rest of the names without typing it individually. Replies are appreciated. Thank-you in advance. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Changing from format style to list style
Should be able to drag/copy the formula down a column and have it increment the
cell addresses. Maybe a sample of your data and the formula would help us help you. Gord Dibben MS Excel MVP On Tue, 21 Nov 2006 22:44:01 -0800, B.W. wrote: I have a group of names that are in form format and want to change them to list format. Once i used the formula on the first name is there a way to apply it to the rest of the names without typing it individually. Replies are appreciated. Thank-you in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I format list of names formatted last,first to first last? | Excel Worksheet Functions | |||
| How to format two repeating XML elements w/o getting list of list | Excel Discussion (Misc queries) | |||
| Format several pages at once w/o data changing (Excel). | Excel Discussion (Misc queries) | |||
| Pivot table Format Style Sheet Capability | Excel Discussion (Misc queries) | |||
| change bahttext format to different format style | Excel Worksheet Functions | |||
Hybrid Mode
