LutonBarry
06-23-2014, 02:43 AM
Folks I hope you can help. I am familiar with the method to insert a carriage return in to a date on for example the x axis of a graph.
01/01/2004 (Entered in cellA1) if I enter in the chart series cell =TEXT($A1,"mmm")&CHAR(13)&TEXT($A1,"yy") it will display the date in the format Jan on one line and 04 on the line below in the chart.
Question is how do I that or can I do that with free text such as that below where a space occurs but in a different place.
Ldn 3rd
Ldn F/C
Ldn SS
OAB
Res Con
RTSS Eur
Thanks for any assistance.
01/01/2004 (Entered in cellA1) if I enter in the chart series cell =TEXT($A1,"mmm")&CHAR(13)&TEXT($A1,"yy") it will display the date in the format Jan on one line and 04 on the line below in the chart.
Question is how do I that or can I do that with free text such as that below where a space occurs but in a different place.
Ldn 3rd
Ldn F/C
Ldn SS
OAB
Res Con
RTSS Eur
Thanks for any assistance.