Splitting columns in Excel 2013
Do you have a list in Excel, perhaps of contact data? Do you have multiple pieces of information in a single column, but need it in two or more? This is most common with names: your report lists names in a single column, but you need the first name and last name separate.
- Choose Delimited and click Next.
- Choose the delimiter separating the pieces of content within the single column (e.g. a space or a comma) and click Next.
- If you need the data output as a special type, select it – otherwise General should work fine.
- Click Finish.
About the Author: siteadmin
Protecting Your Business from Phishing Attacks – Decrease Your ExposureOctober 17th, 2022
5 Common Disasters that Strike Small Businesses - 2022 UpdateApril 5th, 2022
Data Loss Prevention Policy – How to Write one for Your BusinessMarch 1st, 2022
Business Email Compromise - Attacks Are on the RiseFebruary 1st, 2023
Cyber Security Insurance – Why Have My Premiums Risen?January 2nd, 2023
Protecting Your Business from Phishing Attacks - Increasing Your AwarenessOctober 25th, 2022