The file named FormattingDDAnum.xlsx gives a bunch of text strings, such as DDA : D in cell

Question:

The file named FormattingDDAnum.xlsx gives a bunch of text strings, such as DDA : D in cell C4, DDA1250045 in cell C17, and so on. A cell is properly formatted if the first three characters are DDA and the last seven characters are a number 1 million or larger (with no spaces). Determine which cells are properly formatted.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Question Posted: