G
Guest
Good morning,
I'm trying to separate a worksheet containing single cells with mutiple columns of data lumped together. These are some names and addresses, states, zips, all in a single cell for each entry. Looks like this
'Sample Company<strange character>Street Address<strange character>City<strange character>State<strange character>zip
Problem is, there is a strange "square" or block character that denotes the separation of each field. I am told tis is a line break. Text to columns does not recognize this character, and I'm unsure of which character to enter into "other". Does anyone have an idea of what this character is, and/or how to replace it with a comma ? or... a utility or other application to cleanse this data?
Thanks for reading & helping.
DR
I'm trying to separate a worksheet containing single cells with mutiple columns of data lumped together. These are some names and addresses, states, zips, all in a single cell for each entry. Looks like this
'Sample Company<strange character>Street Address<strange character>City<strange character>State<strange character>zip
Problem is, there is a strange "square" or block character that denotes the separation of each field. I am told tis is a line break. Text to columns does not recognize this character, and I'm unsure of which character to enter into "other". Does anyone have an idea of what this character is, and/or how to replace it with a comma ? or... a utility or other application to cleanse this data?
Thanks for reading & helping.
DR