Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 122
Default I need to replace a non printable character, A small white square

I have a discription for an item i'm uploading on to my website. But it won't
upload the small white square or rectangle. I need to replace that item with
a hard enter. Anyone have any suggestions?

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,203
Default I need to replace a non printable character, A small white square

What are you copying from and to? I mean what applications? Excel? Notepad?
into what? An .htm file page?

If it's being copied to an .htm file, try replacing the non-printables with
the <br html tag - which is the equivalent of linefeed w/carriage return.
<br = Break. If you'r unfamiliar with html, you need to type all of that,
including the leading and trailing < symbols.

"Melissa" wrote:

I have a discription for an item i'm uploading on to my website. But it won't
upload the small white square or rectangle. I need to replace that item with
a hard enter. Anyone have any suggestions?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 122
Default I need to replace a non printable character, A small white squ

It's an unknow file but opens in excel. There is a white box where there is a
carriage/return. I want to find all the boxes and replace with the <br. When
i Copy and bring the character over here it's shows up as nothing. It's some
kind of unicode character.






"JLatham" wrote:

What are you copying from and to? I mean what applications? Excel? Notepad?
into what? An .htm file page?

If it's being copied to an .htm file, try replacing the non-printables with
the <br html tag - which is the equivalent of linefeed w/carriage return.
<br = Break. If you'r unfamiliar with html, you need to type all of that,
including the leading and trailing < symbols.

"Melissa" wrote:

I have a discription for an item i'm uploading on to my website. But it won't
upload the small white square or rectangle. I need to replace that item with
a hard enter. Anyone have any suggestions?

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,203
Default I need to replace a non printable character, A small white squ

what does the filename end with? something like .xls or .xl-some other
letter, or .txt or maybe .csv? Have you tried opening it with Notepad? If
you want, and it doesn't contain confidential information you could attach it
to an email and send it to 2kmaro @ dslr.net (remove spaces) and I'll take a
look at it and see if I can't take this to the next level for you?

"Melissa" wrote:

It's an unknow file but opens in excel. There is a white box where there is a
carriage/return. I want to find all the boxes and replace with the <br. When
i Copy and bring the character over here it's shows up as nothing. It's some
kind of unicode character.






"JLatham" wrote:

What are you copying from and to? I mean what applications? Excel? Notepad?
into what? An .htm file page?

If it's being copied to an .htm file, try replacing the non-printables with
the <br html tag - which is the equivalent of linefeed w/carriage return.
<br = Break. If you'r unfamiliar with html, you need to type all of that,
including the leading and trailing < symbols.

"Melissa" wrote:

I have a discription for an item i'm uploading on to my website. But it won't
upload the small white square or rectangle. I need to replace that item with
a hard enter. Anyone have any suggestions?

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 122
Default I need to replace a non printable character, A small white squ

It's a .MDB I will e-mail you what I have. I need the information in column W
in excel. It's the column that has the little blocks where I need a cairrage
return.
Thanks!!!


"JLatham" wrote:

what does the filename end with? something like .xls or .xl-some other
letter, or .txt or maybe .csv? Have you tried opening it with Notepad? If
you want, and it doesn't contain confidential information you could attach it
to an email and send it to 2kmaro @ dslr.net (remove spaces) and I'll take a
look at it and see if I can't take this to the next level for you?

"Melissa" wrote:

It's an unknow file but opens in excel. There is a white box where there is a
carriage/return. I want to find all the boxes and replace with the <br. When
i Copy and bring the character over here it's shows up as nothing. It's some
kind of unicode character.






"JLatham" wrote:

What are you copying from and to? I mean what applications? Excel? Notepad?
into what? An .htm file page?

If it's being copied to an .htm file, try replacing the non-printables with
the <br html tag - which is the equivalent of linefeed w/carriage return.
<br = Break. If you'r unfamiliar with html, you need to type all of that,
including the leading and trailing < symbols.

"Melissa" wrote:

I have a discription for an item i'm uploading on to my website. But it won't
upload the small white square or rectangle. I need to replace that item with
a hard enter. Anyone have any suggestions?



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,203
Default I need to replace a non printable character, A small white squ

..MDB is normally MS Access file. Not a problem, send it on.

"Melissa" wrote:

It's a .MDB I will e-mail you what I have. I need the information in column W
in excel. It's the column that has the little blocks where I need a cairrage
return.
Thanks!!!


"JLatham" wrote:

what does the filename end with? something like .xls or .xl-some other
letter, or .txt or maybe .csv? Have you tried opening it with Notepad? If
you want, and it doesn't contain confidential information you could attach it
to an email and send it to 2kmaro @ dslr.net (remove spaces) and I'll take a
look at it and see if I can't take this to the next level for you?

"Melissa" wrote:

It's an unknow file but opens in excel. There is a white box where there is a
carriage/return. I want to find all the boxes and replace with the <br. When
i Copy and bring the character over here it's shows up as nothing. It's some
kind of unicode character.






"JLatham" wrote:

What are you copying from and to? I mean what applications? Excel? Notepad?
into what? An .htm file page?

If it's being copied to an .htm file, try replacing the non-printables with
the <br html tag - which is the equivalent of linefeed w/carriage return.
<br = Break. If you'r unfamiliar with html, you need to type all of that,
including the leading and trailing < symbols.

"Melissa" wrote:

I have a discription for an item i'm uploading on to my website. But it won't
upload the small white square or rectangle. I need to replace that item with
a hard enter. Anyone have any suggestions?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to remove or replace a carriage return character in a cell? Patty Excel Discussion (Misc queries) 2 July 26th 05 06:25 PM
Search and replace character with in excell cell JRR Excel Discussion (Misc queries) 1 July 22nd 05 08:30 PM
Can I find and replace "white space" in a cell in Excel? biggyb75 Excel Worksheet Functions 7 July 11th 05 04:58 PM
How do I replace a character with another? MosesX8 Excel Discussion (Misc queries) 6 June 11th 05 09:25 AM
How Can I find and replace symbols in excel data ( white square) alawhizkid Excel Discussion (Misc queries) 1 December 14th 04 10:44 PM


All times are GMT +1. The time now is 12:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"