Can this be done?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike - 08 May 2008 15:23 GMT

If I have the following cell values:

B6 contains A
C6 contains 5
D6 contains .35

I need to set cell H6 to:

A,DCS,5A,0V,<.35V,0S,1S

where A is based upon the contents of B6
5 is based upon the contents of C6 and
.35 is based upon the contents of D6.

If I change the values of B6, C6 or D6, the contents of H6 reflect those
changes accordingly.

For example if B6=B, C6=7.5, D6=.3 then H6 becomes
B,DCS,7.5A,0V,<.3V,0S,1S

Can this be done in xcel and if so how?

Thanks

-Mike

Reply to this Message

Ron Coderre - 08 May 2008 15:29 GMT

Try this:
H6: =B6&",DCS,"&C6&"A,0V,<"&TEXT(D6,"#.0###V")&",0S,1S"

Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

> If I have the following cell values:
>
[quoted text clipped - 21 lines]
>
> -Mike

Reply to this Message

Mike - 08 May 2008 15:38 GMT

Thanks Ron

Wonderful!
Yes, this will work. Perfect.

Thanks again :-)

-Mike

> Try this:
> H6: =B6&",DCS,"&C6&"A,0V,<"&TEXT(D6,"#.0###V")&",0S,1S"
[quoted text clipped - 34 lines]
> >
> > -Mike

Reply to this Message

Niek Otten - 08 May 2008 15:41 GMT

Hi Mike,

=B6&",DCS,"&C6&"A,<"&D6&"V,0S,1S"

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| If I have the following cell values:
|
[quoted text clipped - 21 lines]
|
| -Mike

Reply to this Message

Mike - 08 May 2008 15:51 GMT

Thanks Niek!

Looks and works great :-)

-Mike

> Hi Mike,
>
[quoted text clipped - 25 lines]
> |
> | -Mike

Reply to this Message