View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Emma Hope
 
Posts: n/a
Default Bringing together data

I have a column of 7 cells which may or may not contain comments. Such as

A1: Comment 1
A2: Comment 2
A3:
A4: Comment 3
A5: Comment 4
A6:
A7: Comment 5

i wish to have

B1: Comment 1
B2: Comment 2
B3: Comment 3
B4: Comment 4
B5: Comment 5
B6:
B7:

I've tried if statements & i can't get it right, please can any one help.
Thanks