Q: parse string
Hi Jim:
There is feature of Excel that will do exactly what you want.
Pull-down Data Text to Columns...
use the delimited option and space as the delimiter
You can change a whole column this way.
--
Gary's Student
"JIM.H." wrote:
Hello
I have a string in cell that has 4 words in it.
Like xyz abs xyt ttq, how can I get each of this value in a different cell
with a formula?
Thanks,
|