The problem when I use the Replace function is that it replaces all spaces with a ";". This will not work when the entry in one of the columns is less than the column length, e.g. if the column length is 12 and the text entered is length 7, the Replace function will add 5 semicolons instead of one.

How can I return the location of a character? I think that I could use this to get around the above problem.