On Sat, 7 Jan 2012 23:13:49 -0800, "joeu2004" wrote:

"CellShocked" <cellshocked@thecellvalueattheendofthespreadsheet. org wrote:
"siddique" wrote:
cell B3 contains an address 1560 main road Montreal Quebec Canada
[....]
If "B3" is a "city" "field", then it should already be separated.

Maybe if you took the time to read the OP's explanation above, you would
know that it isn't.

Some things should be pre-parsed, and if they are not, we should not
let those who would have us run circles to get to a point of consistency,
get away with 'improper behavior' from a basic computer science
perspective, when what they should be doing is modifying their basic
paradigm.

There is too much "It's all good" going on in too many places these
days.