How to remove leading space in multiple cells of a column in a spreadsheet
How to remove leading space in multiple cells of a column in a spreadsheet
just use the trim function.Formula:Please Login or Register to view this content.
Sorry, could you be a little more specific. I'm just learning excel. Where's the trim function? It starts at A87 to A642. I'm trying to delete the first space which is empty
Thanks
So add a column anywhere an in that column in row 87 typeFormula:Please Login or Register to view this content.
Then copy that cell (CTRL+C) and highlight the column you are in from row 87 to row 642. Then paste (CTRL + V). Now in your new column you will have all the values without leading spaces.
Yes, that worked!! Thanks so much.
No problem. Please click the star underneath this on the left under my profile if I helped you.
Use the TRIM formula for this. This formula removes all spaces from text except for single spaces between words. This is frequently used for information exported from antiquated databases or external applications that may have irregular spacing.
-Brian
www.excel-help.net
Brian,
How would you remove spaces to the left of a text string only, if you wanted to keep the spaces in the text string in tact?
Is there a trim(left(len formula for this or something else I could use?
I.E. - For example below I would only want to remove the spaces to the left of "Dog" but keep the spaces between "Dog" and "Puppy"
_____Dog___Puppy
I am not familiar with an easy way to do it, so I would probably just do it the long way - using the LEN and LEFT formula to peel characters off one at the time and identify them as a space or text.
Then you could use the IF and the CONCATENATE function to put them all back together without the spaces. Would not be too difficult once you developed the initial structure.
If you have any questions, you can email me through my website at www.bburkeconsulting.com -- send the worksheet and i'll take a look.
Thanks,
brian
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks