text to column

[Michael J. Malinsky]

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

HTH

 

[Katie]

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?

 

[Gord Dibben]

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

 

[Katie]

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!!!

 

[Gord Dibben]

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

 

[Gord Dibben]

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