Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
dividing an replacing spaces in string
You guys always steer me right.
How can I do this? I am showing spaces as ~ Everything is in a single cell. I don't need to do anything with the small groups of spaces 1-3 are ok. I need a Line break replacing the larger qtys. However they always vary in length. 2.31~QN~C/AS4~GAW~~~~~~~~~1.03~FW~YELLOW~~J/VVS13~~NEA~~~~~~~~~~~~40.04~HP~F/VVS2~~~MHA ~~~~~~~~~~~~~~~~~~111.51~AD~D/SI~ EMO~~~~~~~~~~~1.20~MX~L/TS~ GHL~ So generally I need, when there is a large span of spaces to convert each group to a vbLf. This newly delimited string will dump into separate rows like this 2.31 QN C/AS4 GAW 1.03 FW J/VVS13 NEA 40.04 HP F/VVS2 MHA 111.51 AD D/SI EMO 1.20 MX L/TS GHL Any ideas? Thanks as always scott |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replacing spaces with data from another cell | Excel Discussion (Misc queries) | |||
Replacing spaces with data from another cell | Excel Worksheet Functions | |||
Replacing spaces with a line end | Excel Discussion (Misc queries) | |||
Replacing spaces with zeros | Excel Programming | |||
replacing spaces? | Excel Programming |