ExcelBanter - How can i remove spaces?

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

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

- - How can i remove spaces? (https://www.excelbanter.com/excel-discussion-misc-queries/134132-how-can-i-remove-spaces.html)

Lion2004

How can i remove spaces?

Hi!

I have excel 2007 and i have imported text into it. Some cells has data with
spaces befor that data. Is it some possibility to remove spaces in all
document?

Thank you.

Gary''s Student

How can i remove spaces?

use
=TRIM()
--
Gary''s Student
gsnu200709

"Lion2004" wrote:

Hi!

I have excel 2007 and i have imported text into it. Some cells has data with
spaces befor that data. Is it some possibility to remove spaces in all
document?

Thank you.

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