oh yeah now i remember
thank you sir


"Jim Thomlinson" wrote:

Either in code or as a worksheet you can use the Trim function...
--
HTH...

Jim Thomlinson


"ernie" wrote:

i need code to remove space from text
for example: A1 = " Brenda"

How do i remove the space infront of Brenda from cell A1?