Copy data from ranges into on column

[cferron]

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.


http://dl.dropbox.com/u/9694362/copy-value.jpg

http://dl.dropbox.com/u/9694362/copy-value2.jpg


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

 

[AUTO]

Hi Claude,

Don't know if this fits the bill or not but, how about this entered if F:

=IF(A5="","",LEFT(A5,3))

Hope this helps

shalom

Auto