LEN function in Excel - Real Business Scenario

Scenario Mode

👤 Your Role: You are a customer service analyst at an online retail company.

📋 Request: Your manager wants to analyze the length of customer feedback comments to understand how detailed the feedback is.

📊 Data: You have a list of customer feedback comments in a column.

🎯 Deliverable: Create a new column that shows the number of characters in each feedback comment using the LEN function.

Sample Data

Customer ID	Feedback Comment
101	Great service and fast delivery
102	Product quality was excellent
103	Delivery was late but customer support helped
104	Not satisfied with the packaging
105	Easy to order and good prices
106	Will buy again
107	Website was confusing to navigate
108	Received wrong item

1

Step 1: Insert a new column next to the 'Feedback Comment' column and name it 'Comment Length'.

Expected Result

A new column titled 'Comment Length' appears next to the feedback comments.

2

Step 2: In the first cell under 'Comment Length' (assuming cell C2), enter the formula to count characters in the feedback comment in B2.

=LEN(B2)

Expected Result

The cell shows the number 29, which is the count of characters in 'Great service and fast delivery'.

3

Step 3: Copy the formula down the 'Comment Length' column for all feedback rows.

Drag the fill handle from C2 down to C9.

Expected Result

Each cell in the 'Comment Length' column shows the character count of the corresponding feedback comment.

Final Result

Customer ID | Feedback Comment                          | Comment Length
------------|------------------------------------------|---------------
101         | Great service and fast delivery          | 29
102         | Product quality was excellent             | 29
103         | Delivery was late but customer support helped | 45
104         | Not satisfied with the packaging          | 32
105         | Easy to order and good prices              | 29
106         | Will buy again                             | 14
107         | Website was confusing to navigate         | 33
108         | Received wrong item                        | 19

✓Feedback comments vary in length from 14 to 45 characters.

✓Longer comments may indicate more detailed feedback.

✓Short comments like 'Will buy again' are brief but positive.

Bonus Challenge

Create a formula to find the longest feedback comment length in the list.

Show Hint

Use the MAX function on the 'Comment Length' column, for example: =MAX(C2:C9)