Counting number of characters in a cell
I have a column with many rows of text (brief product descriptions). I need
to identify which cells have a content of more than 35 characters, since I will need to alter these cells to make them fit a database. Does anyone know how to do so? Thank you. |
Counting number of characters in a cell
Hi,
to test the length use =Len(a1) to return the leftmost 35 characters you don't need to test simply use =Left(a1,35) If the cell is <35 you get all the characters Mike "Still learning" wrote: I have a column with many rows of text (brief product descriptions). I need to identify which cells have a content of more than 35 characters, since I will need to alter these cells to make them fit a database. Does anyone know how to do so? Thank you. |
Counting number of characters in a cell
Use this function:
=LEN(A1) to tell you how many characters (length) are in A1. You can also use: =LEFT(A1,35) to give you the first 35 characters from A1. Hope this helps. Pete On Oct 14, 12:38*pm, Still learning wrote: I have a column with many rows of text (brief product descriptions). I need to identify which cells have a content of more than 35 characters, since I will need to alter these cells to make them fit a database. Does anyone know how to do so? Thank you. |
Counting number of characters in a cell
Thank you very much - was of great help!
"Pete_UK" skrev: Use this function: =LEN(A1) to tell you how many characters (length) are in A1. You can also use: =LEFT(A1,35) to give you the first 35 characters from A1. Hope this helps. Pete On Oct 14, 12:38 pm, Still learning wrote: I have a column with many rows of text (brief product descriptions). I need to identify which cells have a content of more than 35 characters, since I will need to alter these cells to make them fit a database. Does anyone know how to do so? Thank you. |
Counting number of characters in a cell
You're welcome - thanks for feeding back.
Pete On Oct 14, 1:02*pm, Still learning wrote: Thank you very much - was of great help! "Pete_UK" skrev: |
All times are GMT +1. The time now is 08:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com