Removes ALL spaces and commas from a text string

**tccheung** · 09-12-2017, 10:30 PM

For example, the text string as below, there are 23 characters in a text string,
********** 888,000

Request : just need a string of number ie. 888000

Thanks for your helping in advance!

**bebo021999** · 09-12-2017, 10:42 PM

May be:

=SUBSTITUTE(MID(A1,LOOKUP(100,SEARCH({0,1,2,3,4,5,6,7,8,9},A1)),100),",","")+0

**tccheung** · 09-12-2017, 10:51 PM

Thanks bebo021999, you really are an expert, problem solved instantly!!

Removes ALL spaces and commas from a text string

LinkBack

Thread Tools

Rate This Thread

Display

Removes ALL spaces and commas from a text string

Re: Removes ALL spaces and commas from a text string

Re: Removes ALL spaces and commas from a text string

Thread Information

Users Browsing this Thread

Similar Threads

Remove numerous trailing commas from text string that contains commas

Remove numerous trailing commas from text string that contains commas

Importing text file in excel using VBA that removes headers and spaces

[SOLVED] Search Text String separated by Commas and do a Vlookup based on results

[SOLVED] Opening CSV File & It Removes Spaces From Date Columns?

Function MYSTERY!! Need help to extract text strings separated by commas and spaces!

number-to-text conversion removes commas

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions