[computerman29642]

Is there a way to use the LEFT Function with Paste Special?

[OBP]

You can use the left function before using the equivelent of paste special, but does it need to be a paste operation?
Are you "pasting" to more than one cell?

[turbodante]

You want to write code to just copy the leftside of a cell? How a many characters?

Where is it to be pasted? - In place?

[computerman29642]

I apologize for not giving better details.

Here is what I am trying to accomplish.

I need to copy a range of cells H5:H23. I only want to take the first 5 characters. I then need to paste the cells in R5:R23.

[turbodante]

try this

 
Sub Macro2()
For x = 5 To 23
Cells(x, "R") = Left(Cells(x, "H"), 5)
Next
End Sub

[OBP]

turbodante, nice code and not a "paste" in sight

[computerman29642]

Turbodante, very nice.

I have to perform this once more, but what if the cells where the values are going to be pasted are not the same?

For Example, the cells D5 D23 are to be copied and pasted to V25:V43.

[OBP]

Then you would use
Cells(x, "R") = Left(Cells(x+ 18, "H"), 5)

[turbodante]

Originally Posted by OBP

Then you would use
Cells(x, "R") = Left(Cells(x+ 18, "H"), 5)

perhaps OBP mean to say...

Sub Macro2()
For x = 5 To 23
Cells(x + 20, "V") = Left(Cells(x, "H"), 5)
Next
End Sub

..surely

[OBP]

Yep, sorry about that, doing 2 things at once.

[computerman29642]

I have one more scenerio. What if you want to paste this information on a different worksheet?

So, I want to copy data from H5:H23, only take the first five characters, and paste the valus in G32:G52

The reason for all the scenerios is I am still determining which way I plan to setup teh workbook.

[turbodante]

If you want to paste to different sheets

Sheets("target").Cells(x + 27, "G") = Left(Sheets("Sheet1").Cells(x, "H"), 5)

In the above, I've called the sheet where it'll paste 'Target'.

[Though was OBP says, paste without pasting]

[computerman29642]

Thanks Turbodante. You have helped me so much.

[computerman29642]

Thank you OBP as well.

[Zack Barresse]

With the suggestion of an array, it would take out the need to loop through cells, which is generally less efficient than looping through an array. The other option is to use a range of cells and apply a formula to it all at once, use that range to copy at once, delete (clean up) and move as desired. Just more options.