Hello to all forum member
In attached sheet, I want to to remove single or multiple spaces before and after symbol like hash (#) and parenthesis (left, right),
I used trim function but it is not working.
Time format are there next to date with one space. I don't want to touch that part one.
Hi,
please see the file attached
There are for sure better (and more elegant) solutions
Please Login or Register to view this content.
Regards
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
try
=iferror(SUBSTITUTE(SUBSTITUTE(REPLACE(A6,FIND(":",A1)-3,1,"^")," ",""),"^"," "),substitute(A1," ",""))
"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
Re: Remove spaces before and after parenthesis and hash
Space Delimiter.xlsm
Hope this macro works fine for this.
Thanks to both of you.
Thanks Nagarajan.
Suppose I want to use this macro on 3 columns (I, J, K) of sheet1. Can you please help me updating the macro
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks