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?
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. Use Copy>Paste Special..Values to accomplish this. Then Export.
HTH
Bruce
The older I get, the better I used to be.
USA
How are you exporting it?
Doug
Newbie wrote in message <#[email protected]>...
>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?
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks