| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding text or number?
How to add these ?
1) 0XXXXX + 100 = 0XXXXXX, Note: X = numbers, Zero in the front must remain and i need to repeat this for 1000 rows with all different values for all. This mean : 0134000 0134100 0123000 0123100 0924820 092920 2) street 27 street 28 street 29 i want to add Road A at the back of each rows, means street 27 Road A street 28 Road A street 29 Road A What is the formula ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding a Number and Formula Text and Evaluating | Excel Worksheet Functions | |||
| Automate adding in a reference number if the adjacent cell contains text... | Excel Worksheet Functions | |||
| Adding a number to a cell that already has a number. | Excel Discussion (Misc queries) | |||
| adding to a number containing text | Excel Discussion (Misc queries) | |||
| Adding cells, using text as number | Excel Discussion (Misc queries) | |||
Threaded Mode
