Concatenate question
You need to fix the values in your column with the formula in - assume
this is column D, then highlight the column by clicking the letter at
the top of the column. Then click <copy and Edit | Paste Special |
Values (check) | OK and then <Esc.
Now you can delete the original data by highlighting those 3 columns
and Edit | Delete.
Hope this helps.
Pete
On Mar 27, 2:08*pm, DianaL wrote:
I used the concatenate function to combine columns of Last Name, First Name,
Middle Initial. *Now, I want that combined information to remain and I want
to delete the three separate columns. *How can I do that without losing the
concatenate function? *Thanks!
|