In B4 enter the formula

=A4

If this post helps click Yes
---------------
Jacob Skaria


"Confused novice here AGAIN" wrote:

in Colum A row 4 I have the word John or Fred or what ever and i want in
colum b to have a function that tells me A4 is John or fred or whatever i
have there.