We help IT Professionals succeed at work.

Excel replace formula?

K_Deutsch
K_Deutsch asked
on
I have several columns similar to this-
#C5*C8
#C6*C9
#C7*C10
(continues all the way to #C26*C28)

And it should be this (C5 is constant)-
#C5*C8
#C5*C9
#C5*C10
(continues all the way to #C5*C28)

I need a formula that I can apply and come up with the desired results. Thanks.
Comment
Watch Question

Top Expert 2015
Commented:
Assuming you have value in A1 and down..Then you can use this formula...

="#C5*"&RIGHT(A1,LEN(A1)-FIND("*",A1,1))

Open in new window


Saurabh...
Top Expert 2014

Commented:
Press Ctrl + H and then do as shown below.

excel
Top Expert 2014

Commented:
or you can use


=REPLACE(A1,3,1,5)