Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to replace a hard return?
I have a bunch of hard returns at least I think that is what they are. The
data comes from a database on our intranet. I get the data in the form of an excel spreadsheet. But now I have all of the returns. They look like bold bars and when I click in the cell they look like empty boxes. I tried doing a find and replace with ALT 0010. It found a number of returns but not any of the ones I need it to find. If you can help I would appreciate it very much. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to replace a hard return?
let's say that this is the 4th character in the string in A1. In another
cell you could do =code(mid(A1,4,1)) to find out what the ascii code of the character is. -- Regards, Tom Ogilvy "go1angel" wrote in message ... I have a bunch of hard returns at least I think that is what they are. The data comes from a database on our intranet. I get the data in the form of an excel spreadsheet. But now I have all of the returns. They look like bold bars and when I click in the cell they look like empty boxes. I tried doing a find and replace with ALT 0010. It found a number of returns but not any of the ones I need it to find. If you can help I would appreciate it very much. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replace hard return with a delimiter? | Excel Worksheet Functions | |||
Hard return | Excel Worksheet Functions | |||
Replace ; with hard return | Excel Discussion (Misc queries) | |||
Replace double spaces with Hard return | Excel Worksheet Functions | |||
hard return | New Users to Excel |