Removing text and dashes CB-PC-150

**jonasmacs** · 09-13-2008, 02:58 PM

I have thousands of items with boxes that have NBC-AB-440 and ABC-EA-150E, etc. I want to be able to remove the dashes and the first two parts of text (the NBC-AB- & ABC-EA-) so that I am just left with "440" & "150"

Thank you

**VBA Noob** · 09-13-2008, 03:08 PM

This works for your two examples

=MID(A1,8,3)

VBA Noob

**jonasmacs** · 09-13-2008, 03:13 PM

OK... so close...

But how do I get the cell to recognize the new value and not the formula?

I need to compare the last part of the text ("106" compared to "ABC-CE-106")

These I need to sort in a new way. I am trying to avoid having to sit and manually delete "ABC-CE-" from every line. Not every line starts with "ABC-CE-".

Thank you

**arthurbr** · 09-13-2008, 03:25 PM

Not using formulas also consider Data - Text to columns - Check "delimited" - check others and enter "-" ( no quotes)

**VBA Noob** · 09-13-2008, 03:29 PM

Originally Posted by jonasmacs

OK... so close...

But how do I get the cell to recognize the new value and not the formula?

I need to compare the last part of the text ("106" compared to "ABC-CE-106")

These I need to sort in a new way. I am trying to avoid having to sit and manually delete "ABC-CE-" from every line. Not every line starts with "ABC-CE-".

Thank you

Select the column with formula and then copy > right click > paste special > values.

HTH

VBA Noob

**jonasmacs** · 09-13-2008, 04:11 PM

Thank you. I remember that now. Silly...

Thank you for your help

Removing text and dashes CB-PC-150

LinkBack

Thread Tools

Rate This Thread

Display

Removing text and dashes CB-PC-150

Thank you

Duh

Thread Information

Users Browsing this Thread

Similar Threads

extracting text from a cell

sorting numbers with letters and dashes

Adding numbers with dashes

cell entry restricted to text, 2-3 letters & uppercase

Bookmarks

Bookmarks

Posting Permissions