Remove characters

**ymeyaw** · 02-06-2007, 02:49 AM

Dear experts,

I had an excel sheet where some of the datas has characters before the value, how do i remove all of them?
Example:

one of the columns have "parameter=30". What should i do to remove everything except the value "30"?

Thanks

**VBA Noob** · 02-06-2007, 03:17 AM

Hi,

Try

Data > Text to Columns > Delimiter is =

This will split your info info two columns. Delete the first column to leave just the numbers

or with a helper column. Say Data in Col A enter this In Col B and drag down

=RIGHT(A1,LEN(A1)-FIND("=",A1))

Paste special values

VBA Noob

Remove characters

LinkBack

Thread Tools

Rate This Thread

Display

Remove characters

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions