Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stripping spaces using a formula, not VBA
I know hwo to do it using VBA but was asked to perform using only
formulaes, so if anyone could help me? A field in the spreadsheet contains a string built up by up to 8 numbers separated by various numbers of spaces, eg: "12 45 3 2 12 23 2 " Now the output needs to be also a string with the numbers, but only separated by a single space, that is: "12 45 3 2 12 23 2" Can you help me with a formula for that ? :) Thanks in advance! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stripping spaces using a formula, not VBA
On 26 Sep 2006 04:37:12 -0700, "Morris" wrote:
I know hwo to do it using VBA but was asked to perform using only formulaes, so if anyone could help me? A field in the spreadsheet contains a string built up by up to 8 numbers separated by various numbers of spaces, eg: "12 45 3 2 12 23 2 " Now the output needs to be also a string with the numbers, but only separated by a single space, that is: "12 45 3 2 12 23 2" Can you help me with a formula for that ? :) Thanks in advance! Look at HELP for the TRIM worksheet function. --ron |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stripping spaces using a formula, not VBA
Look at HELP for the TRIM worksheet function. --ron "...or multiple embedded space characters ..." thanks a lot I would never imagine that TRIM formula works in a different way than a VBA function. Thank you :) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stripping spaces using a formula, not VBA
On 26 Sep 2006 05:50:38 -0700, "Morris" wrote:
Look at HELP for the TRIM worksheet function. --ron "...or multiple embedded space characters ..." thanks a lot I would never imagine that TRIM formula works in a different way than a VBA function. Thank you :) VBA and Excel are really two different products. There are other functions (e.g. Round) which also work differently in the two programs. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to add spaces in csv | Excel Discussion (Misc queries) | |||
Formula for stripping text | Excel Discussion (Misc queries) | |||
formula to bring value from another sheet with different spaces | Excel Discussion (Misc queries) | |||
how do I remove leading spaces and leave the remianing spaces w | Excel Worksheet Functions | |||
Stripping out imbedded spaces in a cell/row | Excel Worksheet Functions |