Fixed Width Formula

[rmikulas]

Hi all!!

Does anyone know if there is a formula that will look at a cell in a column and only returns the first 4 digits of that column.

I know this can be done by going to DATA -> DATA TOOLS -> TEXT TO COLUMNS and then clicking on "Fixed Width".

The problem is the data is entered all throughout the day, and i was hoping (with a formula) it would just autopopulate into the next column over.

Example:
=if(a1=0," ",unknown formula(a1, 1st 4 digits))

That way if nothing is entered in a1 then it would show blank, but if they entered something in a1 it would change.

Thanks all for your help in advance.