Results 1 to 5 of 5

Thread: Stripping spaces from a number in Excel ...

Threaded View

  1. Oct 11th, 2004, 02:43 AM #1
    TheBionicOrange
    TheBionicOrange is offline

    Thread Starter
    Frenzied Member TheBionicOrange's Avatar
    Join Date
    Apr 2001
    Location
    Cardiff, UK
    Posts
    1,818

    Resolved Stripping spaces from a number in Excel ...

    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


    p.s. I have posted in the VBA forum, but I need an answer pretty quick and no-one is in there
    Last edited by TheBionicOrange; Oct 11th, 2004 at 03:20 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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