I have a worksheet with first, middle and last names of people. The data are
all in separate cells. I would like to combine the name (F M L) in one cell
per name.

I have used CONCENTATE and it works. However, this is a reference formula
which errors when I delete any of the reference cells.

So...I need to find a way to combine a person's first, middle and last name
in a single cell and actually have that data in there (i.e., to not be a
reference).

If anyone has any idea on how to do this (short of having to re-input the
data), I would greatly appreciate it.

Thanks!