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.

Feb 16, 2022 in Others 102 views

## 1 answer to this question.

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 .

• 13,630 points

## Change date format of cell in excel from dd.mm.yyyy to yyy/mm/dd ( excel version 2013 )

Hello :)   Excel’s Format Cells function can quickly ...READ MORE

## Want to compare two columns in excel

Hello To compare two columns in excel ...READ MORE

## Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

## Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

Forget the PsychoPy complications for the time ...READ MORE

## In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

## Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE