Converting the text result of a formula to fixed text?

Hello! I am new here and I have tried to google this question, but I could not find any answers. I suppose there must be a simple one in any case.

I merged 2 cells of info into one: first name + last name with the following formula:

=INITIAL(A7&" "&B7)

The problem is that I now want the displayed text of the formula to be "hard-coded" in the new column. How do you do that?

I am exporting the Excel file to a sales database and I need this first name + last name info to fixed data in one cell.

Thanks in advance!

Select all the data/formulae in the column. Copy it. Without moving the selection/cursor, choose Paste Special | Values.


Regards, TMS

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save