How to simplify this "if" condition?-CodePudding

its me again with another probably trivial question...

is there any way how to simplify (loop?) this condition?

The porpose of this is to make my X-axis label more clear to read rather than how it currently looks

My source data are in following format starting with 2015/Q4,2016/Q1,2016/Q2...up to most recent quater

"=IF(RC[-1]=""2015/Q4"",""2015" & Chr(10) & "Q4""",IF(RC[-1]=""2016/Q1"",""2016" & Chr(10) & "Q1"" ... and so on

CodePudding user response：

What about this:

=SUBSTITUTE(I3,"/",CHAR(10))

Bigben proposed the function, but not the replacement character.

CodePudding user response：

You mean something like:

"=LEFT(RC[-1],4) & Chr(10) & RIGHT(RC[-1],2)"