How to Remove Space before numbers in Excel

In this video, we are going to discuss " How to remove the space in front of the numbers in Excel" In many scenarios we are facing the this problem while pasting the data from the Outlook for any other web sources there will be uneven number of the spaces in front of numerical character which will create mess in calculations, here we can use the substitute function with Char(160) for removing the spaces and convert this to numbers for calculations.


For more videos , visit our website : www.edulap.net
Microsoft Excel Course in Malayalam in Free
Microsoft Excel Course in English in Free
trim spaces in excel

how to remove space in excel before numbers
how to remove space in excel after text
excel trim
how do i remove extra spaces in excel
where is the trim spaces button on the ribbon in excel
how to remove blank cells in excel
how to trim entire excel sheet