DavidStank
New Member
- Joined
- Jan 5, 2016
- Messages
- 15
A problem I've encountered lately is importing data from online sources and coming across characters that look like spaces but aren't recognized by Excel as spaces. This is entirely new to me.
For example, in the formula bar I can click the cursor before a leading letter character and backspace or delete the leading 'mystery character' but expressions such as =IF(LEFT(C1,1)=" "...) returns a value of FALSE every time.
Also, if I delete the mystery character and then strike the space bar to insert a space in its place, expressions similar to the example above will work as expected.
Does anyone know of a formula or function for dealing with these characters or converting them to spaces?
Thanks for any guidance on dealing with these characters.
For example, in the formula bar I can click the cursor before a leading letter character and backspace or delete the leading 'mystery character' but expressions such as =IF(LEFT(C1,1)=" "...) returns a value of FALSE every time.
Also, if I delete the mystery character and then strike the space bar to insert a space in its place, expressions similar to the example above will work as expected.
Does anyone know of a formula or function for dealing with these characters or converting them to spaces?
Thanks for any guidance on dealing with these characters.