Copy and Paste

[rsk]

I need to copy the data from (A5:C10) and paste the same in one cell (D5)


How to do this

 

[NARAYANK991]

Hi ,


What data is present in the range A5:C10 ? Is it text or numbers ? If it is text , how do want the result to appear in D5 ? If it is numbers , what should be the result ?


Can you give one or two examples ?


Narayan

 

[rsk]

Its Text only... i want all data's in D5

Column A Column B

Agent Name Attendance

Mr.X Present

Mr.Y Present

Mr.Z Absent

 

[NARAYANK991]

Hi ,


You have given data in two columns , but the range you mention includes cells C5 through C10 ; what is in these cells ? Are they blank ?


Do you want the data in D5 to be A5 concatenated with B5 , then probably a ";" followed by the data in A6 concatenated with B6 ,... ?


Narayan

 

[Luke M]

I'd recommend using this UDF (not my own, but not sure who original author was)

[pre]

Function ConCat(Delimiter As Variant, ParamArray CellRanges() As Variant) As String

Dim cell As Range, Area As Variant

If IsMissing(Delimiter) Then Delimiter = ""

For Each Area In CellRanges
If TypeName(Area) = "Range" Then
For Each cell In Area
If Len(cell.Value) Then ConCat = ConCat & Delimiter & cell.Value
Next
Else
ConCat = ConCat & Delimiter & Area
End If
Next

ConCat = Mid(ConCat, Len(Delimiter) + 1)
End Function

[/pre]
Then in your worksheet, and you just write:

=CONCAT(" ",A5:C10)

 

[rsk]

D4 : E10 should paste in G12


http://www.2shared.com/file/PQp-A2wM/copy_paste.html

 

[prasaddn]

Hi,


Reading the requirements mentioned, I dont see any further use of data in D5 other than having them in one cell. so, I was thinking...


Why not even copy the contents form A5:C10 and paste them in notepad or other editor and then copy from there and paste in D5??


Regards,

Prasad DN