LinkBack URL
About LinkBacks
Hi ,
I have a list of names in column in excel in which each cell end with some space I want to delete that space in shot .
Please help. I have attached excel for reference.
Thanks and regards,
Shradha
Hi ,
I have a list of names in column in excel in which each cell end with some space I want to delete that space in shot .
Please help. I have attached excel for reference.
Thanks and regards,
Shradha
Last edited by Shradharani; 02-17-2014 at 09:31 AM.
Type this into B2: =TRIM(A2)
This removes space between two words again ... I want only end space to be removed
We have cross-posted - please look at my amended post above.
Thanks its working now
My pleasure!
try this in b2 assuming your data starts from Cell A2
=TRIM(LEFT(A2,FIND(CHAR(9),A2)-1))
Trim Alone will not be able to remove extra spaces in your data!
apply trim formula to certain cell and copy the same then paste as values! There will be spaces !
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks