Tidying up imported text column

  • Thread starter Thread starter Phil Latio
  • Start date Start date
P

Phil Latio

Quick question.

I have imported a column of text and there is annoying space before the
first letter on most lines.

Is it even possible to write some sort of macro that will search highlighted
fields and delete this space if it is the first character (assuming a space
is classed as a character in Excel)? If so, how difficult is this?

Cheers

Phil
 
Try this macro...

Sub RemoveLeadingSpaces()
Dim C As Range
For Each C In Selection
C.Value = LTrim(C.Value)
Next
End Sub
 
Hi,

Since its the only extra space you could enter
=TRIM(A1)
in cell B1 and fill it down by double clicking the fill handle.

This function removes all leading and trailing spaces and all but one space
between each word.

If that might do something you don't want you can use this formula:
=IF(LEFT(A1,1)=" ",MID(A1,2,1000),A1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Special Text to Column question 3
Data Connection with Text Import Problem 8
search text for substring and change text colour of substring 5
typing glitches in Windows Mail 5
Importing delimited text file into excel 4
Help Importing Text Files 1
When importing text field Excel chops off leading spaces 1

Back
Top