Question

3. You want to remove all suffixes, prefixes, and middle initials from the customers' names in column A. Use FlashFill to populate column B with first and last names only. Hint: See Example 1-15 for using Flash Fill found in Module 1 and the Advanced Flash Fill video by Susan.

Name: 3 you want to remove all suffixes prefixes and middle initials from the customers names in column a use flashfill to populate column b with first and last names only hint see example 1 15 fo 73472
Uploaded: 2023-12-09T06:56:14-08:00
Duration: 2 min 9 s
Channel: Akash M
Description: 3 you want to remove all suffixes prefixes and middle initials from the customers names in column a use flashfill to populate column b with first and last names only hint see example 1 15 fo 73472

          3. You want to remove all suffixes, prefixes, and middle initials from the customers' names in column A. Use FlashFill to populate column B with first and last names only. Hint: See Example 1-15 for using Flash Fill found in Module 1 and the Advanced Flash Fill video by Susan.

Added by Daniel A.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Akash M

12/09/2023

Step 1

Step 1: Select column B where you want the first and last names to be populated. Show more…

Show all steps

Thanks for your feedback!

3. You want to remove all suffixes, prefixes, and middle initials from the customers' names in column A. Use FlashFill to populate column B with first and last names only. Hint: See Example 1-15 for using Flash Fill found in Module 1 and the Advanced Flash Fill video by Susan.