Hello,
Thanks for looking into this!
I have multiple strings in a selection set.
My goal is to replace the decimal point with null for a specific requirement.
The requirement is this: "#.## "(Meaning: NUmeric.NumericNumericSpace)
Example String #1: 2.5 kips <---no change
Example String #2: 0.6 %%C <---no change
Example String #3: W1.4 <---no change
Example String #4: 0.086 SQ IN <---no change
Example String #5: 6.2.2 <---no change
Example String #6: SPC1.20 <---This one should be changed to: SPC120
Example String #7: 1.2000 <---no change
Now the real complicated string(multiple decimal points found in the same string.)
Example String # 8: 2.5 kips with 0.6 %%C using W1.4 mesh with 0.086 SQ IN. See 6.2.2 on SPC1.20 for series 1.2000.
#8 should changed to: 2.5 kips with 0.6 %%C using W1.4 mesh with 0.086 SQ IN. See 6.2.2 on SPC120 for series 1.2000. <---Note:SPC120 change
SPC1.20 is the ony part of the string that meets "#.## "(Meaning: NUmeric.NumericNumericSpace)
What would be the best method?
I am very new to VBA, Thank you.
