Can this be done?

[Mike]

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

 

[Ron Coderre]

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)

 

[Mike]

Thanks Ron

Wonderful!
Yes, this will work. Perfect.

Thanks again

-Mike

 

[Niek Otten]

Hi Mike,

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


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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

 

[Mike]

Thanks Niek!

Looks and works great

-Mike