Re: Odd character

To all that supplied an answer:

Thank you all for your input to my dilema.
I did d/l and install the Cell View add-in. I can see where it may be
helpful but in this case it showed up as a 'Special Character'.
This really wasn't much help.

What I ended up doing is taking that column of cells and pasting it into
Word. From there I did a Show All Characters and it ended up being
recognized as a 2 'soft returns' or a Manual Line Breaks.
All I needed to do then was do a find and replace on 2 consecutive line
breaks and replace with a Tab.
Pasting that back into Excel as TEXT automatically created the second column
with the information separated as needed.

Gotta LOVE working with data!!!
I also love these newsgroups. They are a never ending source of new
information!!

Gratefully yours,
Dave French



"VENKAT" <venkat1926xxx@operamail.com> wrote in message
newspsga0lgj0spmm56@ppp76-156.dsl-chn.eth.net...
> see this url
> http://www.mvps.org/dmcritchie/excel/join.htm#trimall
> for this you also nee cell view addin and see this url
> http://www.cpearson.com/excel/CellView.htm
>
> this is for trimming the cell from odd nonprinable characters wwhich is
> normally present in webpages.
> =======================
>
> On Fri, 22 Oct 2004 13:55:32 -0400, David French <nospam@nospam.com>
wrote:
>
> > I have a file that has been exported from Outlook to an Excel file.
> > In some of the address fields the Address1 and Address2 lines are
> > separated
> > by some character that does not seem to be recognized by Excel.
> > In the cell it looks like a 'pipe' character that is bold...sometimes 2
> > of
> > them.
> > In the Formula Bar it appears to be a small box. It also pushes this
> > Address2 to a second line in the formula bar.
> > I need to import this to another program but that program chokes on this
> > character.
> >
> > Can anyone help me to clean this out of the data?
> >
> > Dave French
> >
> >
>
>
>
> --
> Using Opera's revolutionary e-mail client: http://www.opera.com/m2/

If you used Chip's CellView addin, you could see what the offending characters
are--not just that they were special.

In Chip's form, there's a line that shows the decimal/hexidecimal value for each
character.

(right above the Special row)

David French wrote:
>
> To all that supplied an answer:
>
> Thank you all for your input to my dilema.
> I did d/l and install the Cell View add-in. I can see where it may be
> helpful but in this case it showed up as a 'Special Character'.
> This really wasn't much help.
>
> What I ended up doing is taking that column of cells and pasting it into
> Word. From there I did a Show All Characters and it ended up being
> recognized as a 2 'soft returns' or a Manual Line Breaks.
> All I needed to do then was do a find and replace on 2 consecutive line
> breaks and replace with a Tab.
> Pasting that back into Excel as TEXT automatically created the second column
> with the information separated as needed.
>
> Gotta LOVE working with data!!!
> I also love these newsgroups. They are a never ending source of new
> information!!
>
> Gratefully yours,
> Dave French
>
> "VENKAT" <venkat1926xxx@operamail.com> wrote in message
> newspsga0lgj0spmm56@ppp76-156.dsl-chn.eth.net...
> > see this url
> > http://www.mvps.org/dmcritchie/excel/join.htm#trimall
> > for this you also nee cell view addin and see this url
> > http://www.cpearson.com/excel/CellView.htm
> >
> > this is for trimming the cell from odd nonprinable characters wwhich is
> > normally present in webpages.
> > =======================
> >
> > On Fri, 22 Oct 2004 13:55:32 -0400, David French <nospam@nospam.com>
> wrote:
> >
> > > I have a file that has been exported from Outlook to an Excel file.
> > > In some of the address fields the Address1 and Address2 lines are
> > > separated
> > > by some character that does not seem to be recognized by Excel.
> > > In the cell it looks like a 'pipe' character that is bold...sometimes 2
> > > of
> > > them.
> > > In the Formula Bar it appears to be a small box. It also pushes this
> > > Address2 to a second line in the formula bar.
> > > I need to import this to another program but that program chokes on this
> > > character.
> > >
> > > Can anyone help me to clean this out of the data?
> > >
> > > Dave French
> > >
> > >
> >
> >
> >
> > --
> > Using Opera's revolutionary e-mail client: http://www.opera.com/m2/

--

Dave Peterson
ec35720@msn.com

frm cellview if you find chr(160) is the offending item you can remoe it
by using this code

With ActiveSheet.UsedRange
..Replace what:=Chr(160), replacement:=Chr(32)
End With

chr(32) is space.

in one case sometime back I even tried

replacemen:=chr(0) instead of chr(32)
=================================



On Mon, 25 Oct 2004 1320 -0400, David French <nospam@nospam.com> wrote:

> To all that supplied an answer:
>
> Thank you all for your input to my dilema.
> I did d/l and install the Cell View add-in. I can see where it may be
> helpful but in this case it showed up as a 'Special Character'.
> This really wasn't much help.
>
> What I ended up doing is taking that column of cells and pasting it into
> Word. From there I did a Show All Characters and it ended up being
> recognized as a 2 'soft returns' or a Manual Line Breaks.
> All I needed to do then was do a find and replace on 2 consecutive line
> breaks and replace with a Tab.
> Pasting that back into Excel as TEXT automatically created the second
> column
> with the information separated as needed.
>
> Gotta LOVE working with data!!!
> I also love these newsgroups. They are a never ending source of new
> information!!
>
> Gratefully yours,
> Dave French
>
>
>
> "VENKAT" <venkat1926xxx@operamail.com> wrote in message
> newspsga0lgj0spmm56@ppp76-156.dsl-chn.eth.net...
>> see this url
>> http://www.mvps.org/dmcritchie/excel/join.htm#trimall
>> for this you also nee cell view addin and see this url
>> http://www.cpearson.com/excel/CellView.htm
>>
>> this is for trimming the cell from odd nonprinable characters wwhich is
>> normally present in webpages.
>> =======================
>>
>> On Fri, 22 Oct 2004 13:55:32 -0400, David French <nospam@nospam.com>
> wrote:
>>
>> > I have a file that has been exported from Outlook to an Excel file.
>> > In some of the address fields the Address1 and Address2 lines are
>> > separated
>> > by some character that does not seem to be recognized by Excel.
>> > In the cell it looks like a 'pipe' character that is bold...sometimes
>> 2
>> > of
>> > them.
>> > In the Formula Bar it appears to be a small box. It also pushes this
>> > Address2 to a second line in the formula bar.
>> > I need to import this to another program but that program chokes on
>> this
>> > character.
>> >
>> > Can anyone help me to clean this out of the data?
>> >
>> > Dave French
>> >
>> >
>>
>>
>>
>> --
>> Using Opera's revolutionary e-mail client: http://www.opera.com/m2/
>
>



--
Using Opera's revolutionary e-mail client: http://www.opera.com/m2/

the code in my previous message is from mcritchies trimall code to which
the url has been given in one of the earlier messages


On Mon, 25 Oct 2004 1320 -0400, David French <nospam@nospam.com> wrote:

> To all that supplied an answer:
>
> Thank you all for your input to my dilema.
> I did d/l and install the Cell View add-in. I can see where it may be
> helpful but in this case it showed up as a 'Special Character'.
> This really wasn't much help.
>
> What I ended up doing is taking that column of cells and pasting it into
> Word. From there I did a Show All Characters and it ended up being
> recognized as a 2 'soft returns' or a Manual Line Breaks.
> All I needed to do then was do a find and replace on 2 consecutive line
> breaks and replace with a Tab.
> Pasting that back into Excel as TEXT automatically created the second
> column
> with the information separated as needed.
>
> Gotta LOVE working with data!!!
> I also love these newsgroups. They are a never ending source of new
> information!!
>
> Gratefully yours,
> Dave French
>
>
>
> "VENKAT" <venkat1926xxx@operamail.com> wrote in message
> newspsga0lgj0spmm56@ppp76-156.dsl-chn.eth.net...
>> see this url
>> http://www.mvps.org/dmcritchie/excel/join.htm#trimall
>> for this you also nee cell view addin and see this url
>> http://www.cpearson.com/excel/CellView.htm
>>
>> this is for trimming the cell from odd nonprinable characters wwhich is
>> normally present in webpages.
>> =======================
>>
>> On Fri, 22 Oct 2004 13:55:32 -0400, David French <nospam@nospam.com>
> wrote:
>>
>> > I have a file that has been exported from Outlook to an Excel file.
>> > In some of the address fields the Address1 and Address2 lines are
>> > separated
>> > by some character that does not seem to be recognized by Excel.
>> > In the cell it looks like a 'pipe' character that is bold...sometimes
>> 2
>> > of
>> > them.
>> > In the Formula Bar it appears to be a small box. It also pushes this
>> > Address2 to a second line in the formula bar.
>> > I need to import this to another program but that program chokes on
>> this
>> > character.
>> >
>> > Can anyone help me to clean this out of the data?
>> >
>> > Dave French
>> >
>> >
>>
>>
>>
>> --
>> Using Opera's revolutionary e-mail client: http://www.opera.com/m2/
>
>



--
Using Opera's revolutionary e-mail client: http://www.opera.com/m2/