Concatinate worked but...

  • Thread starter Thread starter Newbie
  • Start date Start date
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?
 
You will need to convert the formula to its actual value. Us
Copy>Paste Special..Values to accomplish this. Then Export.

HT
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average from first non-blank cell 12
Dymanic List Range 2
VBA help - error message when line isn't filled out 4
Modify Code to work on Sheets with different names 5
Problem with ExportAsFixedFormat with selected sheets 0
Excel Message box called if 1 of 3 options is entered. 4
Excel Is this possible?? 3
Get Name of Sheet to use in Macro 11

Back
Top