Learn how to use excel generate Batch file

Some time we need to create some batch file with a lot command line from some list , example you have MOSS list in excel then you want add the parameter to stsadm then create batch file.

here is the some command i learn and able to help on the purpose :

=VLOOKUP ( what you want to look , look from where, which column you want the return, false value is exact value)

=REPLACE( start from, start from which location ,how many world u want replace, copy from where )

=CONCATENATE( "string", c1 (Colum parameter)  )
>>>>> results is string [c1 value]