text to column

  • Thread starter Thread starter Michael J. Malinsky
  • Start date Start date
M

Michael J. Malinsky

The squares do represent line feeds. Try formatting the cell to wrap text.

HTH
 
I have spreadsheets that have these squares in the cells
that seem to represent a line return. In the cell it
looks like this:
1234 Walnut (square) road

In the formula bar it looks like this:
1234 Walnut (square)
road

Yesterday I was told to try the text to column,
delimited, other and hold the alt and type 0010 or 0013
which I did and what happened was it would completely
remove everything after the square. Does anyone have any
suggestions?
 
Katie

It was me who gave you the ALT + 0010 advice.

When you enter it in the "Other" box and click "Finish" does your text still
disappear or does it split into 3 columns?

Before you hit "Finish" you will see only the text up to the first square.

Gord Dibben Excel MVP
 
Thank you Gord for your reply today! The answer is that
after I click finish the text after the square
disappears. No longer on the spreadsheet. What exactly
are those squares called because I cannot find any
documentation that can help me through this. THANK YOU!!!
 
Katie

I thought you originally wanted to get rid of the squares(which are most
likely line feeds 0010 or 0013) and break the data into sparate columns.

The operation I described should do that if the squares are line feeds.

They may be something else.

Try David McRitchie's TRIMALL macro code from.....

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

Read the few paragraphs before the actual code to get an idea of what you may
be dealing with.

If you wish, you could email me your workbook and I'll have a look.

Change the obvious in my altered email address to email me.

Gord
 
This problem was resolved with assistance from Dick Kusleika.

Had two line feeds 0010 and 0013 adjacent at 3 points in the data.

Removed and replaced with semi-colon de-limiters via code and Data>Text to
Columns took care of the rest.

Workbook returned to OP with alterations.

Gord Dibben Excel MVP
 
You must log in or register to reply here.

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

Splitting Text from single cell in column across multiple Columns 3
Disable automatic text wrap? 2
expand row to fit 1
text to column 1
LF displays as square box in cell 9
Link text box to a cell 1
Why wont 'autofit' and 'wrap text' remain in tact? 3
How do you wrap larger quantites of text? 4

Back
Top