Results 1 to 8 of 8

Space between to functions on the same cell

This is a discussion on Space between to functions on the same cell within the Excel Questions forums, part of the Question Forums category; Hi there, I have this function and I would like the display to add a space between the functions Code: ...

  1. #1
    New Member
    Join Date
    Apr 2017
    Posts
    7

    Default Space between to functions on the same cell

    Hi there,
    I have this function and I would like the display to add a space between the functions
    Code:
    =IF($A11="","",VLOOKUP($A11,Employees!$A:$AM,2,0)) & IF($A11="","",VLOOKUP($A11,Employees!$A:$AM,3,0))
    At the moment it shows this
    And I want this
    Code:
    Name Surname
    Thanks

  2. #2
    New Member
    Join Date
    Apr 2017
    Posts
    7

    Default Re: Space between to functions on the same cell

    At the moment it shows this "NameSurname"

  3. #3
    Board Regular AliGW's Avatar
    Join Date
    Mar 2014
    Location
    Suffolk, UK
    Posts
    3,594

    Default Re: Space between to functions on the same cell

    Like this:

    =IF($A11="","",VLOOKUP($A11,Employees!$A:$AM,2,0)) & " " & IF($A11="","",VLOOKUP($A11,Employees!$A:$AM,3,0))
    Ali
    Enthusiastic self-taught user of MS Excel!!!

    ForumTools Excel Add-In for HTML Tables (link in the penultimate paragraph):
    http://excelmatters.com/excel-forums/

  4. #4
    New Member
    Join Date
    Apr 2017
    Posts
    7

    Default Re: Space between to functions on the same cell

    Quote Originally Posted by AliGW View Post
    Like this:

    =IF($A11="","",VLOOKUP($A11,Employees!$A:$AM,2,0)) & " " & IF($A11="","",VLOOKUP($A11,Employees!$A:$AM,3,0))
    Now it shows just the formula and nothing else

    thanks

  5. #5
    Board Regular 63falcondude's Avatar
    Join Date
    Jan 2016
    Posts
    3,149

    Default Re: Space between to functions on the same cell

    Quote Originally Posted by vaesir View Post
    Now it shows just the formula and nothing else

    thanks
    It is likely that the cell is formatted as text. Change the formatting from Text to General and then hit F2 Enter.

  6. #6
    Board Regular AliGW's Avatar
    Join Date
    Mar 2014
    Location
    Suffolk, UK
    Posts
    3,594

    Default Re: Space between to functions on the same cell

    That's not because of what I've suggested, though, unless you've removed the = at the start. Check that your cell formatting is not set as text. Delete the formula, set the cell to general and then reapply the formula.
    Ali
    Enthusiastic self-taught user of MS Excel!!!

    ForumTools Excel Add-In for HTML Tables (link in the penultimate paragraph):
    http://excelmatters.com/excel-forums/

  7. #7
    Board Regular Scott T's Avatar
    Join Date
    Dec 2016
    Posts
    669

    Default Re: Space between to functions on the same cell

    You may have accidently turned on show formulas. In the formulas tab of the ribbon check that show formulas is not clicked.
    Colonel Sandurz: Prepare ship for light speed.
    Dark Helmet: No, no, no, light speed is too slow.
    Colonel Sandurz: Light speed, too slow?
    Dark Helmet: Yes, we're gonna have to go right to ludicrous speed.

  8. #8
    New Member
    Join Date
    Apr 2017
    Posts
    7

    Default Re: Space between to functions on the same cell

    Quote Originally Posted by 63falcondude View Post
    It is likely that the cell is formatted as text. Change the formatting from Text to General and then hit F2 Enter.
    Thanks
    Is working now.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com