How to append a character before every cell

[mridz]

hi,

I am an absolute novice so my question might sound very elementary.
What i need to do is very simple.Just append a ' in front value of each of the cells after copying these cells froma different sheet.
I tried to do it the other way round.First have a ' in each of the cells and then copy.
But thats overwriting the '.Is there a way to append the ' to each of the cells after copying.I tried string append but it is saying type mismatch.

Any suggestions would be appreciated.

Thanks
Mridz

[onlyadrafter]

Hello and welcome to the board,

add a column and have ="'" & A1 and copy down as far as necessary, then copy as VALUES into the column where you want the data.

[mridz]

hi..

thanks for your reply,but I could not understand what exactly you are trying to say.
Could you please elucidate.

This is what i am trying to do:
sample.Worksheets("BRACKET444 ASSEMBLY ").Range("A2:V127").Copy
oSheet.Range("a2").PasteSpecial
bracket 444 assembly is the excel sheet from which I am copying the values.
Theres a samll catch here.Some of the values have a ' already appended.also some of the cells are empty and need to put a ' in them

I tried out the following:
oSheet.Range("a2:v127").Select(this is not working)

For Each Item In Selection

If ActiveCell.Value = "" Then


ActiveCell.Value = "'"

End If
Next Item
But how do i state the condition that if thers a ' already appended leave it as it is???