Issue On Values when separate it to value and text?

use

Jeff Moden's Delimited 8K split function