Home |
Search |
Today's Posts |
#1
|
|||
|
|||
len function
I have a column of names consisting of first, middle initials(sometimes), and
last. The len function is part of the parsing formula I want to use. But I find that in this case it always returns the number 39. This must be the width of the column rather than the actual count of characters in the cell. The data orginated in a database. How can I "clean up" my data in Excel so that len returns the number of characters in the cell? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions |