can I TRIM Text in entire worksheet? is there any formula ? or require Macro ?
can I TRIM Text in entire worksheet? is there any formula ? or require Macro ?
tryby Chip PearsonPlease Login or Register to view this content.
If your data is in sheet1, I'd put the following formula in sheet2 cellA1 and copy across and down to replicate the range you want trimmed from sheet1
=trim(sheet1!A1)
Then copy the newly created range in sheet 2 and paste it back as values into sheet1
Happy with my advice? Click on the * reputation button below
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks