=LEFT(A1,4)

This will take the first 4 characters starting from the left of the contents
of cell A1.

You can also use RIGHT and MID functions to get characters starting from the
Right or Middle of a cell.

HTH,
Elkar

"InfoLisa" wrote:

Hi,

I have a worksheet that contains three seperate columns. In one column
I have 7 numbers and letters combined. (i.e 2B14122) I want to move the
first four digits into another column, and the first two digits into
another column. How do I do that without copying, pasting and
deleting? I'm sure there is a formula but I can't think of it.

Thanks.