iggydarsa
Well-known Member
- Joined
- Jun 28, 2005
- Messages
- 1,800
- Office Version
- 2019
- Platform
- Windows
Hi everyone,
In Vba how can I read partial strings?
lets say I have "abc 123" (there is space after "abc"), and this string is in cell A1 in Sheet1. I want to read the data UNTIL THE FIRST SPACE, so that I can assign "abc" to my variable.
How can I do that?
Thanks
In Vba how can I read partial strings?
lets say I have "abc 123" (there is space after "abc"), and this string is in cell A1 in Sheet1. I want to read the data UNTIL THE FIRST SPACE, so that I can assign "abc" to my variable.
How can I do that?
Thanks