This is what you need to do

 

1. Format the cell RegistrationNumber  in the spreadsheet that contains mixed data as Text. You should do this from the Format menu in Microsoft Excel. 

2. Create a macro in Microsoft Excel that contains the following

 

Sub Addspace()

   Dim cell As Object

   For Each cell In Selection
      cell.Value = " " & cell.Value
      cell.Value = Right(cell.Value, Len(cell.Value) - 1)
   Next
  
End Sub
     
 
4. Highlight the cell Registration Number in the spreadsheet that contain the mixed data. 
5. Run the macro, and then save the spreadsheet. 
7. Connect the spreadsheet that you created in Excel to Crystal Report.

 

Refresh the report

 

Cheers

Rahul