i am converting data from Word to Excel (not of table data) while
transfering data all the Enter Button signs (square) is also transfered
how can i avoid that? can any one know how to identify Enter Sign ?


--
ExcelPower
------------------------------------------------------------------------
ExcelPower's Profile: http://www.excelforum.com/member.php...o&userid=30964
View this thread: http://www.excelforum.com/showthread...hreadid=515214

Hi,

You can those Enter Button Signs (Square Symbols) into line breaks by
wrapping the cell contents.

- Right Click on the cell
- Select "Format Cells"
- Click on "Alignment Tab"
- under "Text control" section Check "Wrap text"




With regards
NAVEEN

"ExcelPower" wrote:


i am converting data from Word to Excel (not of table data) while
transfering data all the Enter Button signs (square) is also transfered
how can i avoid that? can any one know how to identify Enter Sign ?


--
ExcelPower
------------------------------------------------------------------------
ExcelPower's Profile: http://www.excelforum.com/member.php...o&userid=30964
View this thread: http://www.excelforum.com/showthread...hreadid=515214

thks Navven but sorry it doesnt work By the way i wan solution in Macro
Code not just excel solution still if any one can tell me the way to do
this in excel I would welcome.

with regards

Excel Power


--
ExcelPower
------------------------------------------------------------------------
ExcelPower's Profile: http://www.excelforum.com/member.php...o&userid=30964
View this thread: http://www.excelforum.com/showthread...hreadid=515214

is here no one in this group enough capable to answer this question?


--
ExcelPower
------------------------------------------------------------------------
ExcelPower's Profile: http://www.excelforum.com/member.php...o&userid=30964
View this thread: http://www.excelforum.com/showthread...hreadid=515214

When you speak of the "Enter Square", are you talking about the little
square that shows up in every cell of a Word table? If not, it must be some
kind of special character.

I am not very capable of answering more than basic questions. The experts
here are capable of almost anything! But no one is capable of reading your
code to find out what you are doing and how to do it better. And no one
here gets paid to help, so if something - or someone - looks like too much
trouble, they are likely to get ignored. Why don't you try posting your
code along with an explanation of how you are getting the data out of Word
to populate the Excel file?

Ed

"ExcelPower" wrote
in message ...

is here no one in this group enough capable to answer this question?


--
ExcelPower
------------------------------------------------------------------------
ExcelPower's Profile:
http://www.excelforum.com/member.php...o&userid=30964
View this thread: http://www.excelforum.com/showthread...hreadid=515214

Thanks Ed I think u have got upset , take it is , it is just a strateg
to get every one involved by throwing a challenge. But i have go
solution for this problem
here it is

If Asc(strTest) < 11 Then
If Asc(strTest) < 13 Then
If Asc(strTest) < 12 Then
............................................ continue

so that unnecessary characters like line change(enter key) etc ar
avoide

--
ExcelPowe
-----------------------------------------------------------------------
ExcelPower's Profile: http://www.excelforum.com/member.php...fo&userid=3096
View this thread: http://www.excelforum.com/showthread.php?threadid=51521