Remove spaces before and after parenthesis and hash

[abraham30]

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.

[canapone]

Hi,

please see the file attached

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2," # ","#")," (","("),"# ","#")," #","#")

There are for sure better (and more elegant) solutions

Regards

[martindwilson]

try
=iferror(SUBSTITUTE(SUBSTITUTE(REPLACE(A6,FIND(":",A1)-3,1,"^")," ",""),"^"," "),substitute(A1," ",""))

[nagarajan_ps]

Space Delimiter.xlsm

Hope this macro works fine for this.

[abraham30]

Thanks to both of you.

[abraham30]

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