Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Stripping out imbedded spaces in a cell/row
Excel 2003
Is there a 'Strip' function in Excel 2003 so that I can strip out the imbedded spaces between words/phrases that exist in one cell and put the 'compressed' result in another cell? For example, if I have "Business Profile Stage 3" I'd like to 'strip' the phrase to be 'BusinessProfileStage3". I just need to strip the spaces out, nothing else (at this time..!!!). [Feature creep still exists!!] I'm creating program variable names from useable phrases so the I can understand what I did at a later date. TIA, Tom [PS: Trim strips leading and trailing spaces but not imbedded. Using an "AT" or "FIND" doesn't do it universally as I never know how many spaces I'll need. Unless there's a creative way to iteratively find all spaces and remove them.] |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
remove spaces in text in excel | Excel Discussion (Misc queries) | |||
Sumproduct ... Empty Cells vs Spaces? | Excel Discussion (Misc queries) |