Field names - replace the space with "_"

viswamtulasi

I'm reading the data from excel where the field names having the space in-between and I would like to replace the space with "_" 

Example:   Dept No,  Dept Name

I would like to see the Field Names as:  Dept_No,  Dept_Name 

I've more than 80 fields, instead of manual rename from Select Tool is there any better option and will you please suggest. 

Thanks in advance.

ponraj

Attaching a sample workflow for your case.  You can also achieve your results using Dynamic Rename tool with following configuration options. 

Rename Mode: Formula

Select the fields you want to rename

Expression: Replace([_CurrentField_], " ", "_")