Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to find truncated entries?
Hello,
I've exported an access table into excel. In the process, it looks like some of the entries were truncated. How can I find all cells with 255 characters? I'd like to check each one for possible truncation. Is there a function that will do this? Thanks, Ellen |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to find truncated entries?
Are all entries supposed to have at least 255 characters?
=IF(LEN(A1)<255,"Truncated","Good") LEN function tells you the length of text in a cell. You could of course change logic to , or =. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "EllenM" wrote: Hello, I've exported an access table into excel. In the process, it looks like some of the entries were truncated. How can I find all cells with 255 characters? I'd like to check each one for possible truncation. Is there a function that will do this? Thanks, Ellen |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to find truncated entries?
You might try Conditional Formatting. Select the column that the entries are
in, then click Format/Conditional Formatting on Excel's menu bar. Select "Formula Is" from the first drop down and copy/paste this formula into the empty field next to it... =LEN(A1)=254 Change the column letter from my example "A" to the column letter(s) for the column you selected above. Next, click the Format button, select the Patterns tab and pick a color (a light tinted one works best), then OK your way back to the worksheet. Any cells 254/255 characters long will be highlighted in the color you selected. (I chose 254 just in case a trailing space at the end of the entry might be removed by the process you are using to import the text.) -- Rick (MVP - Excel) "EllenM" wrote in message ... Hello, I've exported an access table into excel. In the process, it looks like some of the entries were truncated. How can I find all cells with 255 characters? I'd like to check each one for possible truncation. Is there a function that will do this? Thanks, Ellen |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to find truncated entries?
Testing for text in A1 use =LEN(A1)
This will return the number of characters including white spaces. Paul "EllenM" wrote in message ... Hello, I've exported an access table into excel. In the process, it looks like some of the entries were truncated. How can I find all cells with 255 characters? I'd like to check each one for possible truncation. Is there a function that will do this? Thanks, Ellen |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to find truncated entries?
Thanks!!! :o)
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find truncated cells | Excel Discussion (Misc queries) | |||
find the same entries and calculate sum | Excel Worksheet Functions | |||
how to find and add multiple entries | Excel Worksheet Functions | |||
How do I find duplicate entries in Excel | Excel Discussion (Misc queries) | |||
Find duplicate entries | Excel Discussion (Misc queries) |