Alpha and Digits info, need to remove spaces from digit characters?

**gsmonk** · 03-07-2008, 11:56 AM

Hello All,

I have a spreadsheet with a column of alpha/letters and digit/numeric info in it. The problem is the numbers have spaces between them, how can I remove the spaces between the numbers but not the letters/words? I know this can be done but it is beyond me.

Thanks for all the help,

greg

**oldchippy** · 03-07-2008, 12:07 PM

Hi,

Can you give a few examples what your data looks like?

**gsmonk** · 03-07-2008, 04:41 PM

Hello oldchippy,

Here are some examples.

Generic Gold Plus 1 2 0caplets
Generic 5 0 / 5 0 Balanced Remoisturz 1 2 8oz
Barley Juice Powder 5 0 0mg 2 5 0tab

Regards,

Greg

**VBA Noob** · 03-07-2008, 05:03 PM

What's the expected results

Is it

GenericGoldPlus 1 2 0caplets

or

GenericGoldPlus1 2 0caplets

VBA Noob

**gsmonk** · 03-07-2008, 05:21 PM

What I would like the expected results to be:

Generic Gold Plus 120caplets
Generic 50 / 50 Balanced Remoisturz 128oz
Barley Juice Powder 500mg 250tab

I would like to remove the spaces between the numeric digits.

Regards,

Greg

Alpha and Digits info, need to remove spaces from digit characters?

LinkBack

Thread Tools

Rate This Thread

Display

Alpha and Digits info, need to remove spaces from digit characters?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions