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



Dinesh

On Mar 1, 6:08*pm, 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

Save your workbook.
Use the function palette to enter the TRIM function in a column to the
right of the names.
Enter the cell reference of the name.
Drag the function down the length of the list of names.
Copy all of the resulting names.
Select the first cell in the original column of names.
Right click and select Paste Special.
Select Values only.
Delete the TRIM formulas
If you like the results, Save the workbook.

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

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

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


.

On the off-chance your cells might have a combination of 1, 2, or more
leading blank spaces, or even possibly some of them having no leading blank
space, you can safely use this formula to perform a "left trim" on the text
for all of these cases...

=MID(A2,FIND(LEFT(TRIM(A2)),A2),LEN(A2))

--
Rick (MVP - Excel)


"Dinesh" wrote in message
...
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


.