sorting data after import

[ld morrow]

Hello, I have imported into excel 2003 data from a database (file maker pro)
in csv format and one of the variables has 5 numerical values in one cell.
How do I separate each number into five separate cells?

Each number is separated by a symbol that looks like a rectangle standing on
its narrow end rather than a comma, colon etc. I have tried to copy the
symbol into the 'find' option with a view to using 'replace' to get a comma
between the numbers and then maybe? there is a way to split them into
separate cells, but the programme doesn't paste the symbol into the 'find'
field (just blank).

The ss has over 4000 rows and i really would not fancy doing this manually!!!

many thanks for your help!!!

 

[tim m]

Is the number being treated as a number or test I wonder?

If the numbers are always the same length (5) then you could try
highlighting all cells in the row and using 'text to columns'. you could
then click on 'Fixed length' and manually click between each number and the
symbols. You should then end up with each number in a column. (you may end
up with symbols in columns as well but you could just delet those columns.)

 

[Gord Dibben]

I would download Chip Pearson's cellview add-in to see what that character is
then deal with it.

http://www.cpearson.com/excel/CellView.aspx


Gord Dibben MS Excel MVP

On Fri, 27 Jun 2008 09:56:00 -0700, ld morrow <ld