Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I would like help on my function
Hello, I will need your assistance. I have in field of Excel an address. Sometimes in this address, it sometimes happens to have a special character which is a square. How to remove it and replace it by a space. I wish to make a function which starts to seek this character in each cell of C6 with C65000. It must pass from cell to cell, to check in the string cell if this character is present and so yes to replace it by a space but how to do that. I started but I cannot continue Here my code: Sub test() For Each Cell In Worksheets("Feuil1").Range("C6:C65000") Replace(ActiveCell.Value, Chr$(7), " ") Next Cell End Sub Example in my cell: 10, Bvd of London <- here, i ve a square and after an enter key Paris thank you for your assistance Keawee ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming |