ExcelBanter - Trim function to remove blank spaces in Excel

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

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

- - Trim function to remove blank spaces in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/192707-trim-function-remove-blank-spaces-excel.html)

Natty

Trim function to remove blank spaces in Excel

Hi,

I have a worksheet and I would like to delete some blank spaces at the
beginning of text in a bunch of cells. I have tried the TRIM function but
cannot get it to work. Can anyone help? I can email an example of the
spreadhseet I am having problems with. Thanks!
--
Nat

Gary''s Student

Trim function to remove blank spaces in Excel

Make sure they are genuine blanks and not some other invisible character like
CHAR(160)
--
Gary''s Student - gsnu200793

"Natty" wrote:

Hi,

I have a worksheet and I would like to delete some blank spaces at the
beginning of text in a bunch of cells. I have tried the TRIM function but
cannot get it to work. Can anyone help? I can email an example of the
spreadhseet I am having problems with. Thanks!
--
Nat

All times are GMT +1. The time now is 08:23 PM.