Hello, me again.
I'm thinking the index function could help me do this, but I'm not sure how.
I want the values from ranges to be copied in column F.
So A5:C14 --> would give me in column F 517, 518, 519, 520, 521, 522, 523, 122, 123, 124, 125, 126, 127, 128. And so on for other ranges A16:C25.
I also need to remove anything between ( )
Thanks a million.
Claude
I'm thinking the index function could help me do this, but I'm not sure how.
I want the values from ranges to be copied in column F.
So A5:C14 --> would give me in column F 517, 518, 519, 520, 521, 522, 523, 122, 123, 124, 125, 126, 127, 128. And so on for other ranges A16:C25.
I also need to remove anything between ( )
Thanks a million.
Claude
![copy-value.jpg](/board/proxy.php?image=http%3A%2F%2Fdl.dropbox.com%2Fu%2F9694362%2Fcopy-value.jpg&hash=27ea021c86b9e8c7c846551d7fcee8d1)