| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting up with numbers and text
Hi i am trying to count up +1 to each cell which is easy enough but i have
added text to the original cell and it has stopped working. for example cell 1 has LN1000 my formulae at the moment reads (A1+1) i want the answer to be LN1001 is it possible? I am a novice at excel so i reckon its dead essy for an expert. Thanks in advance. Phil |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting a mixed text/number column based on text in another colum | Excel Discussion (Misc queries) | |||
| Counting Occurrence of Text within Text in Cells in Range. | Excel Worksheet Functions | |||
| Counting rows containing data (both numbers and text) | Excel Worksheet Functions | |||
| Counting NUMBERS &/or TEXT from a column to other sheet ? | Excel Worksheet Functions | |||
| Counting Numbers with Text | Excel Worksheet Functions | |||
Threaded Mode
