Blank space

D

Dinesh

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



Dinesh
 
S

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
Click to expand...

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.
 
M

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
 
D

David Biddulph

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


Matt Geare said:
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
Click to expand...
 
R

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