Hi Everyone,

Is it possible, on formulas such as a VLookup, or a Index/Match, to ignore spaces within the cell values? My Query Data returns values that often times has 6 spaces in front of it. For example: " 6101093". Can you set a formula to ignore spaces in front of a value, no matter how many spaces are there? I know i could make another column and use a Left/Right formula to ignore the spaces, but every time I refresh the query, it won't update these formulas unless I do it manually.

Any ideas/help would be greatly appreciated!

Take care.