Thanks:  0
Likes:  0

# Thread: Space between to functions on the same cell

1. ## 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. ## Re: Space between to functions on the same cell

At the moment it shows this "NameSurname"

3. ## 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))

4. ## Re: Space between to functions on the same cell

Originally Posted by AliGW
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. ## Re: Space between to functions on the same cell

Originally Posted by vaesir
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. ## 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.

7. ## 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.

8. ## Re: Space between to functions on the same cell

Originally Posted by 63falcondude
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.

## User Tag List

#### Posting Permissions

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