Wrapping in EXCEL 2003
Wrapping in EXCEL 2003
(OP)
Greetings,
I know that there is a limit on the characters that can successfully be wrapped in EXCEL, to some degree. I still can't figure out how to resolve my problem. The only way presently to fix the probelm is to auto-size the cell. For example, I have the following in a cell:
Measure the OIP3 (dBm) for the RMC FRU, and calculate the IIP3 using the formula, OIP3=IIP3+Gain. Or, measure the IIP3 and calculate the OIP3.
This test is the standard two-tone test. There are three sources of error that should be considered when making distortion measurements on devices with low intermodulation products. These three are:
1) Interaction between the test equipment
Ensure that there is adequate isolation between the two signal generators. Use Isolators, LPFs, attenuators and amplifiers if available to increase the isolation. If resistive power combiners aren't available, use Mini Circuits family of 2-way, 0 degree power splitters, such as ZFSC-2-5. Tie spectrum analyzer and two generators together via 10 MHz reference.
2) Dynamic range of the spectrum analyzer
The usual quick check to determine if the analyzer in generating internal distortion due to input signals that are too high, is to increase the analyzer's input RF attenuator by 10 dB and verify that there is no change in the signal level of the IM products. If the IM product levels do change when the input attenuator is switched, the analyzer is generating internal distortion products and the input signal level is too high to make a valid measurement.
3) Quality of equipment
Use the 8644A or equivalent low-noise generators for greater sensitivity.
Choose a spectrum analyzer with adequate dynamic range, such as a Agilent E4440 or equivalent
Some of the cell wraps, but some doesn't wrap. There are already "ALT-Enter" commands in the cell, but yet there still is a problem. What must I do to see and print all that actually is within a cell? Thanks for your consideration.
John
I know that there is a limit on the characters that can successfully be wrapped in EXCEL, to some degree. I still can't figure out how to resolve my problem. The only way presently to fix the probelm is to auto-size the cell. For example, I have the following in a cell:
Measure the OIP3 (dBm) for the RMC FRU, and calculate the IIP3 using the formula, OIP3=IIP3+Gain. Or, measure the IIP3 and calculate the OIP3.
This test is the standard two-tone test. There are three sources of error that should be considered when making distortion measurements on devices with low intermodulation products. These three are:
1) Interaction between the test equipment
Ensure that there is adequate isolation between the two signal generators. Use Isolators, LPFs, attenuators and amplifiers if available to increase the isolation. If resistive power combiners aren't available, use Mini Circuits family of 2-way, 0 degree power splitters, such as ZFSC-2-5. Tie spectrum analyzer and two generators together via 10 MHz reference.
2) Dynamic range of the spectrum analyzer
The usual quick check to determine if the analyzer in generating internal distortion due to input signals that are too high, is to increase the analyzer's input RF attenuator by 10 dB and verify that there is no change in the signal level of the IM products. If the IM product levels do change when the input attenuator is switched, the analyzer is generating internal distortion products and the input signal level is too high to make a valid measurement.
3) Quality of equipment
Use the 8644A or equivalent low-noise generators for greater sensitivity.
Choose a spectrum analyzer with adequate dynamic range, such as a Agilent E4440 or equivalent
Some of the cell wraps, but some doesn't wrap. There are already "ALT-Enter" commands in the cell, but yet there still is a problem. What must I do to see and print all that actually is within a cell? Thanks for your consideration.
John





RE: Wrapping in EXCEL 2003
RE: Wrapping in EXCEL 2003
RE: Wrapping in EXCEL 2003
RE: Wrapping in EXCEL 2003
RE: Wrapping in EXCEL 2003
ANy one who wants to then clicks on the red triangle to see the comment which woul be the bulk of your text.
e.g. in the cell put:
"Measure the OIP3 (dBm) for the RMC FRU, and calculate the IIP3 using the formula, OIP3=IIP3+Gain. Or, measure the IIP3 and calculate the OIP3."
and put the rest in the comment "This test is the standard two-tone test. There are three sources ....." etc.
JMW
www.ViscoAnalyser.com
RE: Wrapping in EXCEL 2003
Thanks.
John
RE: Wrapping in EXCEL 2003
I2I
RE: Wrapping in EXCEL 2003
Why can't you directly export to Word?
TTFN
RE: Wrapping in EXCEL 2003
John
RE: Wrapping in EXCEL 2003
I guess this limit is either outdated or (as I suspect) it is the supported limit, and anything you get above that is a bonus but unpredictable.
RE: Wrapping in EXCEL 2003
John
RE: Wrapping in EXCEL 2003
RE: Wrapping in EXCEL 2003
I2I
RE: Wrapping in EXCEL 2003
RE: Wrapping in EXCEL 2003
RE: Wrapping in EXCEL 2003
RE: Wrapping in EXCEL 2003
=mid(a1,1,256) will show the first 256
=mid(a1,257,256) will show the next 256
and so on
You can facilitate display by letting another cell hold the starting point for viewing, say a2
=mid(a1,a2,256) will show the first 256 if a2=1
if you want you can add a spin button with the linkcell set to a2 so you can change the starting point by clicking the spin button. By setting teh large change property to 256 you could flip through 256 charactor chuncks of your report
for each click of th espin button.
RE: Wrapping in EXCEL 2003
Paste the text from the OP into a single cell (you have to paste it to the formula bar) and you can see the entire text displayed in the cell. As stated before, this is outside Excel's stated limits, but it works. However, formatting is squirrely, hence the OP.
RE: Wrapping in EXCEL 2003
I just tried that in Excel 2002 and it didn't work, after the first few wraps, it gives up and the only way to see the sentences is to drag the column width out.
JMW
www.ViscoAnalyser.com
RE: Wrapping in EXCEL 2003
If you’re typing directly into an Excel cell, use the enter key as the carriage return on a mechanical typewriter.
RE: Wrapping in EXCEL 2003
CODE
Dim txt As String, NewTxt As String, c As String
Dim i As Long, n As Long, LastSpace As Long
NewTxt = ""
txt = ActiveCell.Value
n = 0
For i = 1 To Len(txt)
c = Mid(txt, i, 1)
If c = " " Then LastSpace = Len(NewTxt)
If (c = Chr(10)) Then
ActiveCell.Offset(n, 1).Value = NewTxt
NewTxt = ""
n = n + 1
ElseIf Len(NewTxt) = 255 Then
i = i + LastSpace - Len(NewTxt)
ActiveCell.Offset(n, 1).Value = Left(NewTxt, LastSpace)
NewTxt = ""
n = n + 1
Else
NewTxt = NewTxt & c
End If
Next i
End Sub
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.