![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
New Member
Join Date: May 2002
Posts: 15
|
Dear all,
I have a huge amount of numbers running in a column. I wonder how I can add something in front and after each number in each cell. i.e 74914440300 in this example I want to add a * in front of the number and the figure 8 in the end. the result should then be. *749144403008 Thelast digit (8) is to be linked from another cell. How would this be possible ? It is way to many cells to make this manually. Appreciate all your help with this. Thank you ! /JE |
|
|
|
|
|
#2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Board Regular
Join Date: Mar 2002
Location: Hellas
Posts: 553
|
HELLO THERE
TAKE A LOOK AT THE FORMULA COPY IT DOWN COLUMN B AND IT'S DONE
You can see the value of cells only click each above hyperlinks
__________________
Best Regards Andreas
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|