for example a column with "erick [enter] widya" when exported it put 'widya' one row below 'erick' where it need to be in same row so when imported back otherwise it return error

is there a way?

my final effort is : using somekind Spesial Character to replace [Enter] whenever it saved into a table so it can fit in one row when exported and when read back just replace those Spesial Character with [Enter]

but i just need to be sure that there's no other way

thanks