THIS SHOULD BE SIMPLE TO DO BUT I CAN'T FUGURE OUT HOW

[Guest]

HERE IS WHAT I WANT TO DO. I HAVE VALUES IN DIFFERENT CELLS ON MY SHEET. I
WANT TO HAVE THEM APPEAR IN A DIFFERENT CELL IN BETWEEN TEXT LIKE THIS:

BLA BLA BLA CELL A1 BLABLABLA CELL A2 B;ABLABLA CELL A3

ANY SUGGESTIONS?
THANKS IN ADVANCE!

 

[Michael Malinsky]

="bla bla bla "&A1&" bla bla bla "&A2&" bla bla "&A3

--
Michael J. Malinsky
Pittsburgh, PA

"I am a bear of very little brain, and long
words bother me." -- AA Milne, Winnie the Pooh

 

[Frank Kabel]

Hi
try
="bla bla " & A1 & " bla 2 " & A2

 

[Guest]

Chris,
If I understand you right, you should be able to do that by typing a formula
like this:

="The answer to your question is " & A1 & " Dollars."
or you can use Concatenate:
=Concatenate("The answer to your question is ", A1, " Dollars.")

Hope this helps.

Joe B.

 

[Paul B]

Chris, here is one way ="BLA BLA BLA "& A1&" BLABLABLA "& A2 &" B;ABLABLA
"& A3
please turn off caps lock, makes it hard to read
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **

 

[Frank Stone]

Hi.
genaricly the code syntax would be something like
"text" & range("A1") & " " & "more text" & " " & Range
("B1") & " " & "more text" & " " & ect.
but do you want code or a formula. where are you getting
the text.
for formula see =concatenate() in help.

 

[Guest]

THANKS TO BOTH OF YOU. YOU SAVED ME HOURS OF TYPING.

 

[Dave Peterson]

And just in case:

="bla bla" & text(a1,"mm/dd/yyyy") & "bla bla" & text(a2,"$0.00")

If you need to apply some kind of number formatting.

 

[Guest]

sorry don,
caps lock happens. does stuff like that really bother you that much? you
must be a lot of fun at parties. do you do that to your wife and kids too.
i'm joking about the wife and kids thing, guaranteed your gay or at least bi.
who says stuff like that unless your on the fence. did you ever work for
GOVERNOR MCGREEVY!!

 

[AlfD]

Hi!

Apologetic would be OK.
Contrite would be acceptable.
Willing to learn how a community works would be great.
Grateful for help would be a bonus.
Positive feedback is always welcome.
Comments of a personal and tasteless nature are totally unacceptable.
You last post was, I hope, your last post unless you mend your manner
and ways. You might find that unacceptably authoritarian, but, believ
me, you shouldn't expect help from the folk on this ng if you won'
live by the rules of conduct and decency which are accepted by th
community.

I think you owe a few people...

Al

 

[JE McGimpsey]

Don -

Rather than responding to rude children, I recommend just plonking
them...

 

[Don Guillett]

I would if I knew how to plonk. Where is that ng? <G>

 

[JE McGimpsey]

Since I've never used OE, I'm not sure of the steps. In my newsreader,
plonking consists of a two-key keyboard shortcut that adds an author to
my kill file.

 

[Don Guillett]

That kink of plonk I can do. oe6 requires a couple of mouse clicks

 

[Hari]

Hi Don,

Was curious about this. In two of the posts in this subject your posts are
dated for 26th August while in the rest it is for 17th august?

Im using OE6 (and I hope nobody tinkered with my computer settings)

Regards,
Hari
India

 

[Don Guillett]

Nah, someone might have dickered with mine tho. You will notice that I had
atomic clock correct. Sorry.

 

[Don Guillett]

Yell real loud (type in all caps) next time for a faster answer.
Seriously, it is considered poor netiquette and very rude to shout.
"ssssssssss " & a1 & "ssssssssssss"

 

[Don Guillett]

I was trying to help you.