How to count number of characters in xl cell for publisher merge

M

msloell

I am doing a catalog merge in publisher. Data is in XL. Publisher has 255
character limit on merged info. How do I count the characters before I
execute the merge?
 
M

matt hinkle

Hi Biff!
using the =len(a1) works fine unless the cell is empty/blank; it returns count of 1 for blank cell--how do I account for these? I assume it would be an if statement of some kind??



T. Valko wrote:

Re: How to count number of characters in xl cell for publisher merge
31-Aug-08

Use the LEN (Length) function

=LEN(A1

-
Bif
Microsoft Excel MVP

Previous Posts In This Thread:

How to count number of characters in xl cell for publisher merge
I am doing a catalog merge in publisher. Data is in XL. Publisher has 25
character limit on merged info. How do I count the characters before
execute the merge?

Re: How to count number of characters in xl cell for publisher merge
Use the LEN (Length) function

=LEN(A1

-
Bif
Microsoft Excel MVP

EggHeadCafe - Software Developer Portal of Choice
ADO.NET 3.5 Cookbook by Bill Hamilton [O'Reilly]
http://www.eggheadcafe.com/tutorial...99b-d2bd169f4974/adonet-35-cookbook-by-b.aspx
 
D

Dave Peterson

Your cell isn't empty.

Try selecting that cell and hitting the delete key on the keyboard.

What happens to that =len() formula?

If it stays 1, then maybe you have calculation set to manual.
Tools|Options|calculation tab is where you'd change it in xl2003 menus.

My guess is that you have some white space character (space bar or HTML
non-breaking space????) in that cell.



Hi Biff!
using the =len(a1) works fine unless the cell is empty/blank; it returns count of 1 for blank cell--how do I account for these? I assume it would be an if statement of some kind??

T. Valko wrote:

Re: How to count number of characters in xl cell for publisher merge
31-Aug-08

Use the LEN (Length) function:

=LEN(A1)

--
Biff
Microsoft Excel MVP

Previous Posts In This Thread:

How to count number of characters in xl cell for publisher merge
I am doing a catalog merge in publisher. Data is in XL. Publisher has 255
character limit on merged info. How do I count the characters before I
execute the merge?

Re: How to count number of characters in xl cell for publisher merge
Use the LEN (Length) function:

=LEN(A1)

--
Biff
Microsoft Excel MVP

EggHeadCafe - Software Developer Portal of Choice
ADO.NET 3.5 Cookbook by Bill Hamilton [O'Reilly]
http://www.eggheadcafe.com/tutorial...99b-d2bd169f4974/adonet-35-cookbook-by-b.aspx
 
D

David Biddulph

Wrong, Matt! LEN does not return 1 for an empty or blank cell.
For either a completely empty cell or a cell with the empty string ="", LEN
returns zero.
If you are seeing a LEN of 1, you do not have a blank or empty cell; you
have a character in there.
You can see which character with =CODE(A1). If it returns 32, you have a
space, if it returns 160, you have a non-breaking space.
 
D

David Biddulph

Wrong, Matt! LEN does not return 1 for an empty or blank cell.
For either a completely empty cell or a cell with the empty string ="", LEN
returns zero.
If you are seeing a LEN of 1, you do not have a blank or empty cell; you
have a character in there.
You can see which character with =CODE(A1). If it returns 32, you have a
space, if it returns 160, you have a non-breaking space.
 
P

Pete_UK

How did you know his name was Matt, David?

Pete

Wrong, Matt!  LEN does not return 1 for an empty or blank cell.
For either a completely empty cell or a cell with the empty string ="",LEN
returns zero.
If you are seeing a LEN of 1, you do not have a blank or empty cell;  you
have a character in there.
You can see which character with =CODE(A1).  If it returns 32, you have a
space, if it returns 160, you have a non-breaking space.
--
David Biddulph














- Show quoted text -
 
M

Max

using the =len(a1) works fine unless the cell is empty/blank;
.. it returns count of 1 for blank cell

The result should be zero, not 1
You probably have an invisible white space which is causing the error
Try usingTRIM: =LEN(TRIM(A1))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
 
V

Visitor

Visitor said:
In Google Groups, click on Hide Options to see the From header record.

I meant More Options. It changes to Hide Options after you click on More
Options.
 
P

Pete_UK

Of course !!

All I saw was "- Show quoted text -" after your post, and I didn't
think to expand it.

Thanks to all for setting me right <sheepish grin>

Pete
 
P

Prof_Hinkle

Thank you so much for clearing that up! There ARE spaces involved; I
didn't even think to check for that!
Thanks again for the expert help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top