Remove a character from a column

  • Thread starter Thread starter sam
  • Start date Start date
S

sam

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Transfer array element offset value to a matched value 3
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Find/Replace MSWord wildcard characters from within Excel 6
Find and replace a character in a cell with another cell's content 1
stopping a range from calculating 5
How to copy row data from Sheet2 to Sheet1 based on Conditional Date 2
Excel Reference to text returning "0" value on second column 0

Back
Top