Forum home » Delegate support and help forum » Microsoft Excel Training and help » ms excel training london - Separating text with a formula
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
ms excel training london - Separating text with a formula
Resolved · Low Priority · Version Standard
Reply Tue 13 Mar 2007, 09:37Delegate Natalie said...
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
For upcoming training course dates see: Pricing & availability
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
|