Good Morning,
Should be simple for those brianiacs out there.....not me however....
In cell A1, etc.....will be numeric values...the values will either contain 7 characters or 11. In cell C1, etc I would like a formula that determines if there is 7, if so, then put an "x", if not, then nothing....along the line of: if(a1=7,"x",""). Can someone out there help me please.
Thanks in advance.
Results 1 to 3 of 3
Thread: Count Characters (Excel 2000)
-
4 Star Lounger
- Join Date
- Feb 2001
- Location
- Louisville, Kentucky, USA
- Posts
- 595
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2004-11-09 12:50Count Characters (Excel 2000)
Roberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
-
Subscribe to get a FREE chapter from Windows 7 The Missing Manual
This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.
-
Platinum Lounger
- Join Date
- Feb 2001
- Location
- Weert, Limburg, Netherlands
- Posts
- 4,812
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2004-11-09 13:19Re: Count Characters (Excel 2000)
=IF(LEN(A1)=7,"x","")
Jan Karel Pieterse
Microsoft Excel MVP, WMVP
www.jkp-ads.com
Professional Office Developers Association
-
4 Star Lounger
- Join Date
- Feb 2001
- Location
- Louisville, Kentucky, USA
- Posts
- 595
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2004-11-09 13:25Re: Count Characters (Excel 2000)
Thank you very much...works like a charm!
Roberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
