From a workbook query, you import a table that has the following data.

From a workbook query, you import a table that has the following data.

You need to configure the table to appear as shown in the following table.

A . From the Format menu, click Trim.
B . From the Format menu, click Clean.
C . From the Split Column menu, click By Delimiter.
D . From the Extract menu, click Last Characters.

View Answer

Answer: C