Replace Carriage Return with Comma

Problem:

Navigate to Setup > Import / Export > Import CSV records > Import Type = Serialized Inventory Item : Format CSV import file with serial numbers on one cell without manually typing serial numbers which are listed in multiple cells (column).


Sample CSV file for serialized inventory item:

Item Name/Number	Serial Numbers
Item A	SN00001
Item A	SN00002
Item A	SN00003
Item A	SN00004
Item A	SN00005
Item A	SN00006
Item A	SN00007
Item A	SN00008
Item A	SN00009
Item A	SN00010

Based on (Help Guide Topic: Adding New Serial Numbers to Inventory), serial numbers on a CSV file must be separated by comma or space in order to import serialized inventory items.

Perform the steps below edit CSV file (similar to the sample) and consolidate the serial numbers in one cell:  

     1. Open the Excel File.
     
     2. Highlight the Column the contains the Serial Numbers.
     
     3. Right-click select Copy.
     
     4. Open MS Word (2003).
     
     5. Click Edit > Paste > Paste Special (or Press Alt E + S).
          
     6. In the Paste Special window, select Unformatted Text.

     
     7. Click OK.
     
     8. Click Edit > Replace (or Press CTRL + H).
     
     9. In the Find and Replace popup window, enter the following:

• Find what: ^p
• Replace with: ,

          

     10. Click Replace All.
     
     11. Click OK.
     
     12. Click Close.
     
     13. Copy the edited text and use it in the CSV file.