Concatinate worked but...

N

Newbie

I have joined the first name and last name of my sheet using: =I17&" "&J17

But, when I go to export the sheet, it doesn't put anything in where the
forumula is for each row.

How do I turn the displayed names when exporting?
 
S

swatsp0p

You will need to convert the formula to its actual value. Us
Copy>Paste Special..Values to accomplish this. Then Export.

HT
 
Top