Select B1 and pull-down:

Data Text to Columns

specifiy the - as the separator and make A1 the destination.
--
Gary''s Student - gsnu200859


"Vic" wrote:

I need to split the value of cell B 1067-234 into 2 cells. 1067 (numeric)
goes into cell A, and cell B will only retain 234 (numeric). What is the best
way to accomplish this? I will be doing this every day, so the most time
saving solution will be greatly appreciated. Thank you.