| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I remove Char(160) from a cell?
I pasted data into a spreadsheet form an html table. I found there in a
Char(160) character on eoither side of the data. I want to strip this character. This character is an nbsp in HTML. |
|
#2
|
|||
|
|||
|
=SUBSTITUTE(E1,CHAR(160),"")
-- HTH RP (remove nothere from the email address if mailing direct) "Dave" wrote in message ... I pasted data into a spreadsheet form an html table. I found there in a Char(160) character on eoither side of the data. I want to strip this character. This character is an nbsp in HTML. |
|
#3
|
|||
|
|||
|
Thanks that did the trick!!
"Bob Phillips" wrote in message ... =SUBSTITUTE(E1,CHAR(160),"") -- HTH RP (remove nothere from the email address if mailing direct) "Dave" wrote in message ... I pasted data into a spreadsheet form an html table. I found there in a Char(160) character on eoither side of the data. I want to strip this character. This character is an nbsp in HTML. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| remove bold from cell ref headers | Excel Discussion (Misc queries) | |||
| How can I remove a formula from a cell and still have the value? | Excel Worksheet Functions | |||
| Remove the apostrophe (') in Excel cell text values | Excel Discussion (Misc queries) | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
