Solved Query to find values that start with empty string then update

[tmyers]

If I have values that contain an empty string or space as the first "character", how would I go about removing that? In the pricing sheet I am trying to work with, there are quite a few values which begin with a space and it would make my life a lot easier if I could easily remove them.

 

[theDBguy]

Hi. Check out the TRIM() function.

 

[bob fitz]

Perhaps you could use the Trim() function

 

[tmyers]

I thought there was a function specifically for this. Quick and easy answer! Thanks!

 

[theDBguy]

I thought there was a function specifically for this. Quick and easy answer! Thanks!

You're welcome. Bob and I were happy to assist. Cheers!