Converting the text result of a formula to fixed text?

[KarenInStockholm]

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!