Thanks Thanks:  0
Likes Likes:  0
Results 1 to 1 of 1

Thread: how can i add a space to this formula

  1. #1
    Board Regular
    Join Date
    Feb 2016
    Posts
    433
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default how can i add a space to this formula

    In this formula I'm not sure how to add a space between these two cell references. Any help appreciated.

    Code:
    =PROPER(IFERROR(INDEX(PIF_REPORT!$H5,MATCH(PIF_REPORT!$H$4,PIF_REPORT!$H$4,0)),"")) & PROPER(PIF_REPORT!$I$5)
    Solved with
    &" "
    Last edited by Dark0Prince; Dec 1st, 2017 at 05:31 AM. Reason: no longer need answered
    Using Excel 2016, on a windows 10 PC.

Some videos you may like

User Tag List

Tags for this Thread

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
  •