remove empty space from in front and end of an entry

[goodstudent]

AABB123 /// XYZ123

PQR123 @@@ MNO123

Hello Mr Excels,

I have these entries in each cell and there are spaces in front of, in the middle and at the end of each entries. I want to remove spaces only in front of and at the end of entries and I do not want to remove spaces that appear in between the entry. How can I achieve this please:

AABB123 /// XYZ123
So in the above I only want to remove spaces that appear before AABB123 and spaces that come after XYZ123.

PQR123 @@@ MNO123
So in the above I only want to remove spaces that appear before PQR123 and spaces that come after MNO123.

I can't use VBA. I need a formula please.

Thanks in advance for your support!

 

[goodstudent]

here my spaces before and after each entry in a cell got removed automatically. but imagine that there are spaces before and after each entry in each particular cell.

 

[DanteAmor]

Use Trim function

Libro1
	A	B
1	AABB123 /// XYZ123	AABB123 /// XYZ123
2	PQR123 @@@ MNO123	PQR123 @@@ MNO123
Hoja4

Cell Formulas
Range	Formula
B1:B2	B1	=TRIM(A1)

Is that what you need?

 

[goodstudent]

Use Trim function

Libro1
	A	B
1	AABB123 /// XYZ123	AABB123 /// XYZ123
2	PQR123 @@@ MNO123	PQR123 @@@ MNO123
Hoja4

Cell Formulas
Range	Formula
B1:B2	B1	=TRIM(A1)

Is that what you need?

Thanks for your kind response and solution suggested. This looks fine to me and seems to work in the immediate. Let me work with several entries/ cell and I will let you know if it is working fine for all the entries.