can someone help me with a function code that i can use to replace the trim function. i'm working on a project that requires me to use all other excel functions except for the trim function and yet i need to remove both trailing and leading spaces from a cell.
i'm fairly new at vba.
all help will be extremely appreciated
thanks in advance