How to remove enters in fields

[Anonymous]

I have a field in excel as below.

'Safety and security features

(e.g. seatbelts, ABS, airbags, immobilizer, parking sensor, etc.)'

I want to remove enters while loading in qlikview...output should be

'Safety and security features (e.g. seatbelts, ABS, airbags, immmobilizer, parking sensor, etc.)'

how can it be done...

[varshavig12]

=PurgeChar(FieldName,chr(10))

[Anil_Babu_Samineni]

Confusing, Would you elaborate more. You have row level values. Can you explain Values again with Dum Data

[Anonymous]

there is a enter after 'features'  I want a backspace so that output could be

Safety and security features (e.g. seatbelts, ABS, airbags, immmobilizer, parking sensor, etc.)' while loading in qlikview

[MindaugasBacius]

LOAD Replace(A, Chr(10), ' ') as A

FROM

(ooxml, explicit labels, table is Sheet1);

The result: