Substring in excel

Posted by Celops on Stack Overflow See other posts from Stack Overflow or by Celops
Published on 2010-04-28T07:58:28Z Indexed on 2010/04/28 8:03 UTC
Read the original article Hit count: 128

Filed under:

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.

© Stack Overflow or respective owner

Related posts about excel