Substring in excel

Question

I have a set of data that shown below on excel.

R/V(208,0,32)   YR/V(255,156,0)         Y/V(255,217,0)
R/S(184,28,16)  YR/S(216,128,0)         Y/S(209,171,0)
R/B(255,88,80)  YR/B(255,168,40)    Y/B(255,216,40)

And I want to separate the data in each cell look like this.

R/V 208 0 32
R/S 184 28 16
R/B 255 88 80

what is the function in excel that I can use for this case. Thank you in advance.

Answer 1

Hi Basically there is no specific formula for a substring in excel, but u can use different functions like MID, LEFT, RIGHT, FIND, LEN, SUBSTITUTE, REPT, TRIM, and MAX in Excel to extract substrings.

Mid

To extract a substring, starting in the middle of a string, use the MID function in Excel.

This basically takes the mid operation that is from the center of the string operation 
Left

To extract the leftmost characters from a string, use the LEFT function in Excel.

This basically takes the left most part of the string 
Ex: ABC_103 and u use left operation in the excel the output will be ABC 

Right

To extract the rightmost characters from a string, use the RIGHT function in Excel.

This basically takes the right most part of the string .