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 number of letters in a string ...	Larry Wallis	Excel Discussion (Misc queries)	4	February 17th 05 10:11 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:11 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us