Natalie has attended:
No courses
Separating text with a formula
Hello,
I have imported some data into an excel spreadsheet. However, the data has come through as one big block and each word is seperated with "," (see example below)
FakturNr;"Kundennummer";"Firma";"Firma2";"AnPerson";"Vorname";
Is there a formula I can apply to seperate this text into seperate cells?
Thanks,
Natalie
RE: Separating text with a formula
Natalie,
You can use a fundtion called TEXT TO COLUMNS.
1. Select the column that contains the data
2. click DATA > TEXT TO COLUMNS on the menu bar.
3. Step through the wizard, DELIMITED VALUES, specifying that the semi-colon in the delimiter.
4. Excel will space the data into the columnt to the right accordingly.
When you import information to excel, you sometimes get an import wizard that does the same function. Depending on how you import the imformation, sometimes you get it, sometimes not. If you copy and paste, then no wizard, but if you use, DATA > IMPORT EXTERNAL DATA > IMPORT DATA, then navigate to the relevant file, you will get the wizard.
Richard
