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 ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding text or number?
1. put 100 in an un-used cell
2. copy the cell 3. select the cells you want to increment 4. Edit PasteSpecial Add 5. re-select the same cells you just incremented 6. Format Cells... Number Custom 0000000 the last step restores the leading zero. -- Gary''s Student - gsnu200840 "Kiannie" wrote: 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 ? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding text or number?
=A1 & " Road A" entered in B1
Double-click on fill handle of B1 to copy down. Gord Dibben MS Excel MVP On Wed, 18 Mar 2009 09:10:57 -0700, Kiannie wrote: 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 ? |
Reply |
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) |