gibbo1715
03-17-2007, 08:03 AM
Hi All been a while
I have a string that can be a pretty long value
what i need to do is if the string is mnore than 40 chars long add a line break
eg
this is my initial string which is in cell A1 and it goes on and on and on
I need to put it in cell a2 as below
this is my initial string which is in cell A1
and it goes on and on and on
thanks all
Paul
I have a string that can be a pretty long value
what i need to do is if the string is mnore than 40 chars long add a line break
eg
this is my initial string which is in cell A1 and it goes on and on and on
I need to put it in cell a2 as below
this is my initial string which is in cell A1
and it goes on and on and on
thanks all
Paul