Question

on the vehicles worksheet, insert a function into cell b4 of the code column that extracts the two leftmost letters of the vehicle style displayed in cell d4.

Answer 1

Answer: Assuming the "vehicles worksheet" has a table with headers "Vehicle Type", "Year", "Make", "Model", and "Style" and the data starts from row 4, you can use the following formula in cell B4:

=LEFT(D4,2)

This formula extracts the leftmost 2 characters from the text in cell D4, which should contain the vehicle style. Once you enter this formula in cell B4 and press enter, it should display the two leftmost letters of the style in cell B4. You can then copy and paste the formula into the rest of the cells in the B column to extract the style letters for all vehicles.

Explanation: can u add the vehicle worksheet and then i can help