ExcelBanter - How do i scrub leadding spaces in a coloumn in excel

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

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

- - How do i scrub leadding spaces in a coloumn in excel (https://www.excelbanter.com/excel-discussion-misc-queries/264442-how-do-i-scrub-leadding-spaces-coloumn-excel.html)

kpraneeth

How do i scrub leadding spaces in a coloumn in excel

Luke M[_4_]

How do i scrub leadding spaces in a coloumn in excel

You could either use Text to Columns, or the TRIM function.

--
Best Regards,

Luke M
"kpraneeth" wrote in message
...

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