Reference Cell in middle of another cell's text

**RobP614** · 10-08-2009, 01:31 PM

Hello,

I'm trying to reference another cell in the middle of the number that is already in the cell.

So as an example:

if A1 was 9990000_____00360000000
and C1 was 9001.

How can I make the "blank" the number from C1?

Thanks,
Rob

**protonLeah** · 10-08-2009, 11:52 PM

Please Login or Register  to view this content.

*With no info on source of other numbers in A1

**judyj** · 08-13-2012, 12:45 PM

I was looking for this as well and it works great, but can you tell me how to format that referenced cell. I am inserting a percentage in the middle of text that explains the percent but when I insert the reference I get 0.0523145 instead of 5.2% even though the cell referenced is formatted propertly. Thanks so much!

**Ace_XL** · 08-13-2012, 02:08 PM

Perhaps..

="9990000 "&ROUND(C1*100,1)&"% "&"00360000000"

**judyj** · 08-13-2012, 02:56 PM

Thanks so much. That definitely got me on the right track. The sequence that made it perfect was ="9990000 "&ROUND(C1*100,1)&"% 003600000"
I didn't need the third & or the additional ".
Thanks again!

**arlu1201** · 08-13-2012, 03:15 PM

Judyj,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.