M
Michael J. Malinsky
The squares do represent line feeds. Try formatting the cell to wrap text.
HTH
HTH
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
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?
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?
G
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
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
K
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!!!
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!!!
G
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
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
G
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
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