Separating words in one cell into many cells

Hello and good morning!

I am having what they call a brain fart at the moment. I cannot recall the last time I did this and forgot.

All words are in Cell A, separated by the ";" symbol. I want separate into different Cells. Example... Lead_ID in Cell A1, Application Data in A2, Date Purchased in Cell A3 and so on.


lead_id;application_date;date_purchased;first_name;last_name;email;day_phone;work_phone;best_time;city;state;zip;addr;cred_rating;cred_score;yearly_income;prop_state;prop_type;purpose;loan_amount;prop_value;ltv;mtg_bal1;mtg_bal2;services;credit_repair;foreclosure;debt_management;comments

Thank you for any assistance.

Regards,

Excel is cool

Hi,

Please find attached the file with steps.

Thanks
Aravindhan

Thank you all!