how to remove blank space from the excel cell...

Question

1.00/5 (1 vote)

See more:

( DUMRI)
( BHARKATHA)

this word contain space in before the first character D..I want to remove that space

I was used trim function but it is not going to be helped me out..pls give other solution

Posted 5-Mar-15 20:01pm

Member 11337367

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Peter Leow · Answer 1 · 2015-03-05T21:12:00

Solution 1

Refer: How to remove leading spaces in cells in Excel?[^]

Posted 5-Mar-15 21:12pm

Peter Leow

MIllerPuK · Answer 2 · 2015-03-16T16:30:00

Solution 2

I am not sure whether your content include brackets, if not ,solution 1 is perfect;but if include, use regular expression to match and remove black spaces.

Posted 16-Mar-15 16:30pm

MIllerPuK

how to remove blank space from the excel cell...

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

how to remove blank space from the excel cell...

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us