Thank you all. It works pefectly.

Dinesh

"David Biddulph" wrote:

Or =RIGHT(A1,LEN(A1)-1) ?
--
David Biddulph


"Matt Geare" wrote in message
...
Hi,

Another approach which would avoid any unintended consequences of the TRIM
function (TRIM will turn a double space between words into a single space)
would be to do exactly as Slim Slender suggest but use the formula:

=MID(A1,2,LEN(A1))

This will only remove the leading "space".

Cheers,

Matt

"Dinesh" wrote:

I have big database of customers and have blank space beoire the customer
name start. How can i remove it in bunch?



Dinesh


.