| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count number of characters until encounter "&"
I have a cell with the value "577256&S_MSGNUM=4777037808398&". I want
to count the number of characters that appear before the first & symbol so I can do a left() on them. They are always integers, never letters. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count characters within a cell to the left of "/" | New Users to Excel | |||
| Limiting a Column to "X" Number of Characters | Excel Discussion (Misc queries) | |||
| Limiting a Column to "X" Number of Characters | Excel Discussion (Misc queries) | |||
| The number of characters in a "Screen Tip" | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Threaded Mode
