PocketRocket wrote:
I have a list of full names in column A. I want to extract the first name to
the corresponding row in col B. I am using the formula =left(a1,search("
",a1)). It works in B1 but when I copy the formula down the column, I get
the same first name in all cells, (e.g., cell a1 has Joe Smith, cell b1
results are Joe, but so is cell b2, b3, b4.) The column is formatted for
General. I have never seen this behavior before. Anyone have any ideas?
No, I don't want to type the formula over 300 times.


Check that calculation is set to automatic.