Register
Which of these functions in excel is best suited for extracing a substring from within a long text message? A. LOWER B. TRIM C. MID D. LEN E. CONCAT
188k views
5 votes
Which of these functions in excel is best suited for extracing a substring from within a long text message?

A. LOWER
B. TRIM
C. MID
D. LEN
E. CONCAT

User Jeremy Farrell
by
8.2k points

1 Answer

6 votes
Answer: C

Explanation: To extract a substring, starting in the middle of a string, use the MID function in Excel. Explanation: the MID function starts at position 7 (O) and extracts 6 characters.
User Araw
by
7.5k points
Ask a Question
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.

8.8m questions

11.4m answers

Other Questions

“What does it mean when we “rework” copyrighted material?”
The book shows how to add and subtract binary and decimal numbers. However, other numbering systems are also very popular when dealing with computers. The octal (base 8) numbering system is one of these.
Please help me ! All you do is just put it it all in your own words ! Please this is for my reported card!i don't know how to put it in my own words because my English is not that good!
describe an advance in technology that makes life more enjoyable. what discoveries contribute to this technology?
Disadvantages of using animation in advertising? advantages and disadvantages of using animation for education? advantages and disadvantages of using animation in entertainment?
Link Copied!