Blank space

[Dinesh]

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



Dinesh

 

[Slim Slender]

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.

 

[Matt Geare]

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

 

[David Biddulph]

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

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]

Thank you all. It works pefectly.

Dinesh

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





.

 

[Rick Rothstein]

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))