Hiya folks!
Looking for a formula that pulls only the text value and not the spaces to the left of that text value from a cell copied over from MS Project.
When pasted the MS Project data looks like this if we were looking at three vertical cells in one column, where the far left of this message box = the far left of each cell:
_____________xyz
____fti
__________ffo
The number of spaces from cell to cell is different, so I need a formula that can be copied down and will address the removal of various numbers of spaces.
Please halp!!!
Looking for a formula that pulls only the text value and not the spaces to the left of that text value from a cell copied over from MS Project.
When pasted the MS Project data looks like this if we were looking at three vertical cells in one column, where the far left of this message box = the far left of each cell:
_____________xyz
____fti
__________ffo
The number of spaces from cell to cell is different, so I need a formula that can be copied down and will address the removal of various numbers of spaces.
Please halp!!!
