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.

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.