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?