+ Reply to Thread
Results 1 to 3 of 3

Concatinate worked but...

  1. #1
    Newbie
    Guest

    Concatinate worked but...

    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?



  2. #2
    Forum Expert swatsp0p's Avatar
    Join Date
    10-07-2004
    Location
    Kentucky, USA
    MS-Off Ver
    Excel 2010
    Posts
    1,545
    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

  3. #3
    Doug
    Guest

    Re: Concatinate worked but...

    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?
    >
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1