Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove a character from a column
Hello,
I have a excel sheet and I got to replace single quotes in one of the columns and replace the resultant value in the same column. I am relatively new to excel and not able to figure out a way to do that. Thanks, Sam. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove a character from a column
If your single quote is always in position 1 of the cells then use:
Sub nopreapostophe() For Each c In Selection If c.PrefixCharacter = "'" Then c.Value = c.Value Next End Sub HTH "sam" wrote in message om... Hello, I have a excel sheet and I got to replace single quotes in one of the columns and replace the resultant value in the same column. I am relatively new to excel and not able to figure out a way to do that. Thanks, Sam. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove character at end of data | Excel Discussion (Misc queries) | |||
How to remove character format under .csv? | Excel Discussion (Misc queries) | |||
remove last character in a column of part numbers if a "V" | Excel Discussion (Misc queries) | |||
How to remove a character from the first index? | Excel Discussion (Misc queries) | |||
Remove a particular character using formulas | Excel Discussion (Misc queries) |