Larry Wallis

Posts: n/a

Calculating number of letters in a string ...

Looking for a way to calculate the number of characters in a text string. I
can use the LEN function.

e.g. If A1 contains "News Group", the number of characters is 9. Using the
LEN(A1) formula would give me 10 (includes the space).

How can I use this formula to omit the space?

Thanks.

Larry.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculating interest on number of days in the period	Ron	Excel Worksheet Functions	0	January 18th 05 12:59 AM
How can I assign a number to a string?	Jog Dial	Excel Discussion (Misc queries)	3	January 14th 05 03:44 AM
Read Text File into Excel Using VBA	Willie T	Excel Discussion (Misc queries)	13	January 8th 05 12:37 AM
count number of occurences within a string	Gabriel	Excel Worksheet Functions	2	November 25th 04 04:17 PM
GET.CELL	Biff	Excel Worksheet Functions	2	November 24th 04 07:16 PM

All times are GMT +1. The time now is 01:29 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us