How to append a character before every cell

mridz

Board Regular
Joined
Aug 19, 2004
Messages
66
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
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
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.
 
Upvote 0
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???
 
Upvote 0

Forum statistics

Threads
1,213,534
Messages
6,114,185
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top