Remove lines with blanks in front

[rowdy2k5]

Hi!

I have a text file with entries of the following form:

TextLine1

    TextLine2

In the second case, there are 4 blank spaces before there is any text in the line. How do I import only those lines which have no blank spaces in front?
Or: if I import the file as it is, how do I remove all the rows with 4 blanks in front?

 

[krausr79]

Import all, then in cells to the right
=if(left(a1,1)=" ","",a1)

'if the lefthand 1st char in cell a1 is a space, give me nothing, otherwise give me a1

 

[rowdy2k5]

I get #NAME error when inputting that formula.

 

[Michael M]

Try

=TRIM(A1)

and copy down as far as needed

 

[rowdy2k5]

Trim does not help me much, because then I have a list with all entries in A1, with no spaces in front. But I want to delete those entries with spaces in front. I don't want to delete the spaces in front.

 

[rowdy2k5]

Import all, then in cells to the right
=if(left(a1,1)=" ","",a1)

'if the lefthand 1st char in cell a1 is a space, give me nothing, otherwise give me a1

Ok, that works. Let's say I have now entries, where some entries have 2 spaces in front and others have 4 spaces in front. How do I need to change the formula to keep those with 2 spaces in front?

 

[BenMiller]

=if((left(a1,2)=" ")*(NOT(left(A1,4)=" ")),"",a1)