An alternative to using Text to Column to extract the part that you need from a mix of data.
For example, if you have: firstname.lastname@example.org you might want to extract each person’s surname.
Alternatively use Text to Column found under Data Tab.
- Type Pisani then fill down
- Click on the AutoFill Options smart tag
- Select Flash Fill
(only available in version 2013 forward)
Offering Customized Computer Training Courses, we come to you.
Some of my clients in the area are Hino, Toyota, Taren Point Hotel, Civic, Caltex Refineries, Sutherland Shire Care Support Service. Visit website reviews