Column Left

[MECO]

I have a LONG column of text. Each row begins with a space. How can move all rows one space to the left ?

[shg]

In an adjacent column, =mid(a1, 2, 32767)

Then copy, paste as values, and delete the original column.

[popipipo]

You can also use 'Text To columns'
Limiter/breakline after first character
Not import first column.

[MECO]

I'm not quite sure how I did it but your suggestion was what I needed.

Thank you

[shg]

I like popipipo's suggestion better than mine.

[6StringJazzer]

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved.

Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon below their name.