I have the following data in C1 to D6
Paid Received
£90.00
£598.68
£4.38
£50.00
£66.12

The amounts are in text format with spaces after the last digit.

In Column E I'm trying to create a formula like =if(C2<"",-C2,D2) so I get
a single column of figures where amounts paid show as negative.

I've tried using Trim but it doesn't remove the space after the amount so
even with a formula like =if(C2<"",-Value(Trim(C2)),Value(Trim(D2)) I get an
error as it won't convert the trailing space to a value.

I'm afraid I'm stuck. How do I remove the spaces and get a value?

Can anybody give me a steer on this please. All help much appreciated.

Thanks a lot