Hi,
I suggest trying text to columns on the column F:F.
1) Select column F:F
2) Data - Text to Columns (on the menu bar)
3) Delimited
4) Choose ' as the delimiter
5) Finish
Does that work?
Regards,
A
"vipa2000" wrote:
I have the following data. i need to count those recorrds where there length
is less than 12 characters.
I used =SUMPRODUCT(--(LEN(Sheet1!F:F)<12)) but excel falls down saying the
cells are formatted as text or contain an apostrophe. i tried to format the
cells as general but still won't work. Other users will use this so i don't
want a lot of user intervention.
FunctLocation
12087359305PV1525
12087325530DRIVE
12087350101
12087320109PV4201
12087325350PIPING
12087325001
12087325759LR-F01
--
Regards vipa
|