Give this a try:

In cell A20 entered this formula
=ROW(A1)&". "&A1&". "&ROW(A6)&". "&A6&"."

Hope that helps,
Jim K

"Maggie" wrote:

I have a worksheet where one cell is basically where information is
dumped into it from another cell. I want to have the cell that has an
issue be numbered 1,2,3 and be dumped cell with the numbers. Is there
a way to do that?

For example:
Cell A1 has Missing file
Cell A6 has No Coverage
Cell A20 reads 1. Missing file. 6. No Coverage.