Dear Team,
we have received some data from customer, in that, after each name there is some extra spaces, is there any way to remove ending spaces
please see the below some samples, till "-" spaces are there, total i have 1 lakh names like that, please help me with solution
Name
VIMAL RAJ M -
CHANDRAKALA B -
DEEPA GOMEZ -
Regads
Vimalakar
Hi use functionIf it will not help send the sample of data in excel file
Please Login or Register to view this content.
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
Assuming your data is starting in A1.
In B1 and drag down: =TRIM(SUBSTITUTE(SUBSTITUTE(A1,CHAR(160),""),"-",""))
Oh by the way, did you find your answer in this thread, as it still is not been marked as "Solved"!
http://www.excelforum.com/excel-gene...13#post2912413
depends on the space there are more than one type! if its just a normal few spaces ,select the column,then use text to columns ,fixed width.
click next until you see the preview ,double click any break lines to remove them,click finish
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks