Copy column with values without blamks at the end

[gio123bg]

Hi All,
I need ti copy a column of values (where data include some blank at the end) to a new column but without blanks at the end. More exactly.

From Col A

A4603979bbbbbb
A4603982bbbbbb
A4643074bbbbbb

where bbbb=blanks

To Col B

A4603979
A4603982
A4643074

Thanks in advance.
Regards,

Giovanni
























видеорегистратор с монитором























новости Харьков

 

[jeffreybrown]

How about...

=TRIM(A1)

 

[gio123bg]

Thanks a lot!
Problem solved!

Regards,

Giovanni

 

[jeffreybrown]

Ciao Giovanni,

Glad it help you