Wrapping in EXCEL 2003 1

[JohnCerny]

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

 

[vzeos]

Try this: Paste the OP’s sample text into a Word document and turn on the format display (and turn off auto numbering.) At the end of each line hit the enter key so that you have a [¶] character at the end of each line. Now copy the modified text and paste it into the formula bar in Excel. You should get cell text that looks just like your Word text.

If you’re typing directly into an Excel cell, use the enter key as the carriage return on a mechanical typewriter.

 

[joerd]

You can use the following code to convert the data in the active cell into a number of cells to the right of the active cell. If you want, you can implement it as a function, taking as arguments a text string and a destination range, for example. Feel free to modify.

Sub WrapIt()
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.