Analysing data

Originally Posted by i_ujala

Hi,

I have got some data from XML sheet when imported to excel it's giving a sigle row of data rather than dividing to columns (including table charachtors).

Ex: (I paste this directly from the excel sheet - 5 rows of data)

┌─────┬───────┬───────────┬────────┬───────────┬──────────
│مسلسل│ر.بيان │ت.البيان │ر.أيصال │ت.الأيصال │ مواصفــات الســيارة │الكمية│الوزن │ ├───────┼───────────┼────────┼───────────┼────────────────
│ │الحافظة│ت.الحافظة │المنشأ │الماركة │ طراز السـيارة والموديل │ رقــم المكينــــة │ رقــم
│232 │3615C │11/04/2006 │3830 │12/04/2006 │هافي مينيه دباب │

can anyone give a simple solution where I can divide the data into columns whilst ignoring the imported table charachtors (┌─────┬─)

Thanx


Ujala

Hi,

try select column A, then Data, Text to Columns, and Delimited, Other and use │ as the special separator.

hth
---