|
-
Oct 11th, 2004, 02:36 AM
#1
Thread Starter
Frenzied Member
Stripping spaces from numbers
I've got a column of numbers.
Each number is 19 digits long, and there are NO leading zeros.
Unfortunately, these numbers have intermittent spaces in the middle of them which I need to strip out.
e.g. 292 393 67675363 98769
I tried using the INSTR function, but that was giving me some weird results.
This is pretty urgent, so any input would be greatly appreciated.
Cheers
Steve
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|