Adding figures to a cell

[Tojje]

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

[sen_edp]

HELLO THERE

TAKE A LOOK AT THE FORMULA
COPY IT DOWN COLUMN B AND IT'S DONE

Microsoft Excel - HtmlMaker.xls
File(F) Edit(E) View(V) Insert(I) Tool(T) Data(D) Window(W) Help(H)
D7		=
	A	B	C	D	E
1	234234	:alert('*2342348')>=+"*"&A1&C1	8
2	45645	:alert('*456458')>=+"*"&A2&C2	8
3	645645635	:alert('*645645635')>=+"*"&A3&C3
4	45453	:alert('*454538')>=+"*"&A4&C4	8
5	234234	:alert('*2342348')>=+"*"&A5&C5	8
6	45645	:alert('*456458')>=+"*"&A6&C6	8
7	645645635	:alert('*645645635')>=+"*"&A7&C7
8	45453	:alert('*454538')>=+"*"&A8&C8	8
9	45453	:alert('*454538')>=+"*"&A9&C9	8
10	45451222	:alert('*454512228')>=+"*"&A10&C10	8
11
12
Sheet2

You can see the value of cells only click each above hyperlinks