Hello,
I have a spreadsheet that has rows contain text and dash such as tcu - OU. These spaces between dash and text are not consistent, some of them have double space in between and they are very hard to look. Is there a way that I can make them consistent by having one space in between and no space at the end?
Thanks
hi tantcu. TRIM would remove preceding, trailing spaces & maintain 1 space between each character. so
=TRIM(A1)
copy down
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
You can use =TRIM function to remove double spaces and trailing spaces and spaces in the beginning of the string.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Hi,
If you mean that a cell might have,"tcu - OU"", etc. then tryPHP Code:"tcu - OU
Formula:
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
I would think the easiest way would be a find and replace. Find __-_ and replace with _-_ where the underscore represents the space.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks