Adding text in same cel as formula??

**dugexcel** · 01-06-2009, 01:03 AM

I have a list of numbers in column A (i.e.: 1234)and I need them to show up in column B in with an "*" asterisk on each side on the number (i.e.: *1234*). So I was using "=a1" in cell B1, is there away to add the asterisk to the formula as text?? Thanks, Doug, [email protected]

**mudraker** · 01-06-2009, 01:06 AM

="*"&a1&"*"

Or use custom formatting

"*"0"*"

**dugexcel** · 01-06-2009, 01:18 AM

WOW !! That was fast and it worked great!! Thanks so much !!

**mudraker** · 01-06-2009, 01:41 AM

If my reply has solved your problem please mark your Thread as Solved by editing your original podting, advanced tab, Change Tile prefix to Solved

**Madrabbitwoman** · 01-06-2009, 07:28 AM

Just wanted to add an option (aka complicate things!) - I use =CONCATENATE whenever I need to mix formulas, numbers and text.

Type =CONCATENATE( and then add each item with a comma separating them.

EG: cell B15 has BEER written in text and cells C15 and D15 have 1 and 3 in them, then the following formula:

=CONCATENATE("I'll have ",SUM(C15+D15)," pints of ",B15)

Would result in the following value:

I'll have 4 pints of BEER

Don't know if you'll find that helpful, perhaps I'm a bit dislexic in that too many symbols get me confused, but a big formula title followed buy a simple list, is easier to work with.