On Sat, Feb 7, 2015 at 4:59 PM, Kaj 70147pers...@telia.com wrote:
Assuming your string is in cell A1, cell B1 could contain:
=CONCATENATE(MID(A1,12,5), - ,MID(A1,34,5))
A wee more safe could be:
=CONCATENATE(MID(A1,12,5), - ,LEFT(RIGHT(A1,8),5))
In all fairness to Kaj, his
Sorry for the late reply, life got in the way.
On Sat, Feb 7, 2015 at 4:43 PM, Brian Barker wrote:
Try:
=MID(A1;12;5) - MID(A1;34;5)
This works, after I realized that I had to change A1 to the appropriate
reference number.
Thanks! To all that replied, it all helped.
Cheers,
See below...
On Sat, Feb 7, 2015 at 4:59 PM, Kaj 70147pers...@telia.com wrote:
If this is a simple string, then the extract is quite simple. But if it
contains date formulas in a way, it is a wee more complicated. But let us
start with the simple assumption, that the string is exactly the
Sorry for my posts going all over the place. Just learning how to use gmail
for a mailing list.
See below...
On Sat, Feb 7, 2015 at 4:43 PM, Brian Barker b.m.bar...@btinternet.com
wrote:
At 15:22 07/02/2015 -0700, Jerry Van Brimmer wrote:
Column A has the following data:
2015-01-06
Thanks for reading, but I just manually formatted one page, and then I can
copy/paste to other pages.
Sorry for any inconvenience.
I'd still like to know how to do it though. I'm thinking a macro is really
what I need.
On Sat, Feb 7, 2015 at 2:22 PM, jerryvb jerry...@gmail.com wrote:
Column
I'm using 4.3.1.2 on Xubuntu Linux.
I am creating some lesson handouts for a class I'm going to be teaching. I
have to email them to our secretary, who has to read them in MS Office for
printing.
The documents are formatted in landscape mode.
In the document I enter a short text line, press
? (Sorry, just
trying to give you arguments but they are unlikely to win you any fans!)
Good luck and regards from
Tom :)
Thanks.
On 24 September 2014 00:12, J. Van Brimmer jerry...@gmail.com wrote:
Thanks Cley,
I didn't think about the pdf route. That just may well work. I did try
On Tue, Sep 23, 2014 at 9:47 PM, Tim Lloyd tim.ll...@gmx.com wrote:
Hi,
I was able to recreate this with Fedora 20 and LO 4.3.1 - has this been
reported as a bug? If not I have an account and I can log it.
Has not been reported. I didn't consider that it might be a bug.
A few
On Sun, Sep 14, 2014 at 7:35 PM, Owen Genat owen.ge...@gmail.com wrote:
Yes. Prior releases used the Print File Directly button and in v4.3 this
has been replaced with the Print... button. As Valter Mura indicated this
can be changed by customising the toolbar i.e., it is the default display
I'm currently using LibreOffice 4.3.1.1 Impress. When I'm adding text
inside of a text box and press Enter, Impress automatically adds a
round bullet at the begining of the new line. I've looked around in
all of the Impress options, and can't find where to turn it off. How
do I turn it off?
--
Thanks Tom and Brian for your tips...
I finally figured it out. Left click Inside the text box in a slide.
Then right click in the text box and select Bullets and Numbering.
Click on the Customise tab. For Number select None, and for
Level select 1 - 10. Click on OK. Now auto-bulleting is off
+1
On Aug 10, 2014 7:19 AM, Jim Seymour jseym...@linxnet.com wrote:
On Thu, 07 Aug 2014 18:10:50 +0200
Errol Goetsch er...@xe4.org wrote:
[snip]
Thank you to the developers who have given so much to so many for
so little.
[snip]
Hear, hear!
Regards,
Jim
--
Note: My mail server
+1
On Aug 5, 2014 6:42 PM, arakish rmfrun...@gmail.com wrote:
It is of my opinion that you should stick with the standards.
What is wrong with calling the newest possible stable version Release
Candidate, the proven stable version Stable, the unstable beta-tester
version Beta?
It makes
Done.
On Jun 30, 2014 7:14 PM, Joel Madero jmadero@gmail.com wrote:
Don't forget to join to keep up to date with US based events!
https://plus.google.com/communities/111758039218283143648
Best,
Joel
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
I am just beginning to learn Impress. I am in the process of creating my
first slide presentation. For my first slide, I used one of the Available
for use slide Master Pages After adding my text on the slide, I pressed
F5 to view the slide full screen. (I still have an old 1280x1024 monitor.)
At
On Jun 25, 2014 10:22 AM, Regina Henschel rb.hensc...@t-online.de wrote:
Hi,
J. Van Brimmer schrieb:
I am just beginning to learn Impress. I am in the process of creating my
first slide presentation. For my first slide, I used one of the
Available
for use slide Master Pages After adding my
I have noticed that somewhere along the update path, the borders around
charts inserted into Calc have disappeared. I'm now using LO 4.2.3.3 on
Linux. But I don't know exactly when it happened. When I create a new
chart, and set up a border, the border doesn't show up.
Sorry, Willian, I know this
Here's mine:
% TimeImportance
Writer 95 95 Homework
research projects
Calc5 5 banking
Impress 0 0
I'm using LibreOffice 3.5.4.2 on Debian Linux. After I create a
footnote on a page, say page 1, and create a footnote, let's say
Footnote # 1, how can I create a second footnote to reference the same
footnote #1? All I want for the second footnote is a superscript
numeral 1 in the body of the
...@btinternet.com wrote:
At 13:25 10/03/2014 -0700, J. Van Brimmer wrote:
I'm using LibreOffice 3.5.4.2 on Debian Linux. After I create a footnote
on a page, say page 1, and create a footnote, let's say Footnote # 1, how
can I create a second footnote to reference the same footnote #1? All I want
On Sun, Mar 2, 2014 at 9:54 AM, Johnny Rosenberg gurus.knu...@gmail.comwrote:
2014-03-02 7:00 GMT+01:00 J. Van Brimmer jerry...@gmail.com:
Hello,
I'm new to the list, so if this is an inappropriate subject, please let
me
know.
I am using Libreoffice on Manjaro Linux. Over the last
it wouldn't come to that, but maybe
I'll have to create a new, fresh spreadsheet. That would be a LOT of work
though.
On 2 March 2014 11:48, Cley Faye cleyf...@gmail.com wrote:
2014-03-02 7:00 GMT+01:00 J. Van Brimmer jerry...@gmail.com:
Hello,
I'm new to the list, so
I'm sorry, if that was me. I'm new to the list, and using Gmail. I just now
realized what I had done this morning. From now on I will hit Reply-All and
then edit out individuals email addresses.
[?]
On Sun, Mar 2, 2014 at 10:53 AM, Jim Seymour jseym...@linxnet.com wrote:
On Sun, 2 Mar 2014
still on
the same team really.
Before doing the fresh new spreadsheet route i would try just removing
the direct formatting. It might be worth trying a rename of the User
Profile too jic either of those ideas do work.
Regards from
Tom :)
On 2 March 2014 22:08, J. Van Brimmer jerry
24 matches
Mail list logo