Excel Indirect Sheet Name With Space

I need to find cells with text that have more than one space between the first and last names.

Excel indirect sheet name with space. Join date 06 22 2004 location surrey england ms off ver excel 2013 posts 4 964. I am fairly new to excel. I have a sheet name with a space in it so i know that i have to wrap the sheet name in quotes which works if i hard wire the specific cell reference into the indirect formula but i d like for the cell reference to be based on the contents of another cell. Excel handles those references by surrounding the sheet name in single quotes apostrophes.

Any help would be appreciated. Excel questions spaces in worksheets and. If there is a space in the worksheet then the indirect function returns ref. On the contrary when i removed the single quotes that wrapped the worksheet name with space i e.

The following formula works fine unless there is a space in the worksheet name. So the reference string in cell a1 would be. Sheet space e8 converting that to an indirect reference you can copy down the column would look. In return excel refused to cooperate and gave me.

Basically i have a sheet name and a cell reference in cells a1 and a2 of sheet1 as. I can find the space after the first word but cannot tell it to find ones that say have a space then another string of text. Thank you for your help. Has space a1 excel opened following dialogue box requesting me to select a file with an intention of locating the file that carries the sheet name i said no to excel by clicking cancel.