This feature works great when I type information in. But when the cell I want to split refers to another cell it doesn't work. for example, if I type in cell a1, Cleveland Ohio then have cell b1=a1 the information comes over but the text to column feature won't work. Any ideas?
Dan
Dan