ExcelBanter - Trim and clean

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Trim and clean (https://www.excelbanter.com/excel-discussion-misc-queries/128399-trim-clean.html)

Wanna Learn

Trim and clean

Hello Can I use the clean and trim function at the same time? If so how?
Thanks

Teethless mama

Trim and clean

Yes, you can

=TRIM(CLEAN(A1))

"Wanna Learn" wrote:

Hello Can I use the clean and trim function at the same time? If so how?
Thanks

Elkar

Trim and clean

Just place one inside the other.

=TRIM(CLEAN(A1))

HTH,
Elkar

"Wanna Learn" wrote:

Hello Can I use the clean and trim function at the same time? If so how?
Thanks

All times are GMT +1. The time now is 06:06 AM.