Results 1 to 4 of 4

INDIRECT ref text from same sheet with spaces

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-10-2019
    Location
    Penang, Malaysia
    MS-Off Ver
    2016
    Posts
    262

    INDIRECT ref text from same sheet with spaces

    Hi All,
    I just did for SUM & INDIRECT.. however it returns #REF! for ref text with spaces. How can this be solved?
    what i did to the text with spaces is to put _ (underscore) in between but what i want to achieve is text with spaces


    Thank-You very much!
    Attached Files Attached Files
    Last edited by chaiyya345; 09-24-2019 at 11:01 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 9
    Last Post: 12-31-2018, 01:29 PM
  2. [SOLVED] Including spaces in cell lookup/INDIRECT reference
    By Crawfy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-09-2018, 05:01 AM
  3. Removing Spaces from Defined Names So that INDIRECT Still Works
    By Jutt369 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-03-2016, 07:22 PM
  4. [SOLVED] Indirect Formula Reference with Spaces
    By sdavidheiser in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-30-2015, 04:30 PM
  5. [SOLVED] Indirect function not working with spaces
    By exarranum in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-14-2013, 12:30 AM
  6. Indirect Formula to return Text from one sheet to cell in another sheet
    By lou031205 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-04-2007, 02:51 PM
  7. Indirect doesn't work when sheetname have spaces
    By ExcelQuestion in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-26-2007, 05:33 PM

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