extract data from a string of information

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi,

could someone assist, i would like to separate the data which is captured
between the |
see below the example formats.

the data is in a Excel spreadsheet, the results must be added in separate
columns.


format 01
D5.163006S.634000.DA | Company ABD GMBH & CO. KG | 205904 | CLINV0003547 |
1399

format 02
D5 - 163006S - 634000 - DA|Company Services GmbH
|199563|CLINV0010648|1431|20070817|85942

thanks,

Jan
 
Check out TTC.
<Data> <Text To Columns>

Follow the steps in the wizard.

Post back with any questions.
 
For RagDyer
I am also looking for a way to seperate info, mine has a backslash between
each piece (a .GED file) I don't know what TTC is can you help? Thanks.
 
Data>Text to Columns as RD wrote just under TTC

Use backslash as "other" delimiter.


Gord Dibben MS Excel MVP
 
"text to columns" from the data pull down, thanks Gord I have used that
successfully now
 
Back
Top