Splitting first name and surname

[gemmas25334782]

Hi,

I need to split first name and surname into different columns when I export a customer report.

Is this possible? If so, how would I do it?

Thanks,

Joe