how to remove space from cell

Shahkalson

New Member
Joined
Jul 28, 2010
Messages
3
hi,

Some time data contain number of spaces before text/data when copied form somewhere in a cell . Can anybody tel m how can i remove that space other than mannually.

Thaxx
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Watch MrExcel Video

Forum statistics

Threads
1,109,505
Messages
5,529,264
Members
409,859
Latest member
emperorgenghiskhan
Top