Ian wrote...
....
Secondly, try the solution below. It assumes your original data is in A1.

=LEFT(A1,6) gives the first 6 characters
=RIGHT(A1,LEN(A1)-6) gives everything after the first 6 characters
....

Easier than using RIGHT call is using MID,

=MID(A1,7,1024)

Note that if LEN(A1) < 6, RIGHT(x,LEN(x)-6) returns a #VALUE! error
while MID(x,7,1024) returns "".