View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lamb Chop[_2_] Lamb Chop[_2_] is offline
external usenet poster
 
Posts: 10
Default name cells with their adjuscent cells

How can I do a batch naming of a series of cells by the cells next to them.

e.g.

A1 = apple B1=10
A2= orange B2=12
A3= banana B3=5

I want to name B1 to apple, B2 to Orange and B3 to banana.

At the moment, I enter them manually. Are there any better way?

Thanks in advance.