Extract Value of Cell by Character

I have a workbook that combines two values into one cell and separates them by a slash ( / ). I need a macro to grab the data before or after the "/". I run into a problem when the value is more that one digit.

See attached workbook sample.

Hello Ricker090,

Use can do this very easily using the Split method. his will split a delimited string into a a 1-D array. Each element can then be returned directly. Here is your code with this change added.

Please Login or Register  to view this content.

Ricker090,

There are a few ways you can do this...

Please Login or Register  to view this content.

Or you can use formulas:

Please Login or Register  to view this content.

Sorry Leith, same idea just some other options