Converting two-column (separated by tab character) MS Excel2007 document to two-series ASCII file in PRN format

Home and Applets > FAQ > About NMR > About File Conversion > Excel2007 to ASCII in PRN Format

Converting two-column (separated by tab character) MS Excel2007 spread sheet document to two-series ASCII file in PRN format

  1. In Excel2007, click Save icon, a message appears:
  2. Click No button:
    Choose the file type Text (separator: space); then click Save button.
  3. The following message appears:
    Click Yes button.
  4. Close the window:
  5. The following message appears:
    Click No button.
  6. A new file with the same name appears on the Desktop of Windows:
    This new file has PRN format.
  7. Open with right-hand button the new file for Excel:
  8. The intensity data appear in a single column:

Solid-state NMR bibliography for:

Aluminum-27
Antimony-121/123
Arsenic-75
Barium-135/137
Beryllium-9
Bismuth-209
Boron-11
Bromine-79/81
Calcium-43
Cesium-133
Chlorine-35/37
Chromium-53
Cobalt-59
Copper-63/65
Deuterium-2
Gallium-69/71
Germanium-73
Gold-197
Hafnium-177/179
Indium-113/115
Iodine-127
Iridium-191/193
Krypton-83
Lanthanum-139
Lithium-7
Magnesium-25
Manganese-55
Mercury-201
Molybdenum-95/97
Neon-21
Nickel-61
Niobium-93
Nitrogen-14
Osmium-189
Oxygen-17
Palladium-105
Potassium-39/41
Rhenium-185/187
Rubidium-85/87
Ruthenium-99/101
Scandium-45
Sodium-23
Strontium-87
Sulfur-33
Tantalum-181
Titanium-47/49
Vanadium-51
Xenon-131
Zinc-67
Zirconium-91
[Contact me] - Last updated February 20, 2020
Copyright © 2002-2020 pascal-man.com. All rights reserved.