LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 01-27-2014, 06:19 AM   #1
knobby67
Member
 
Registered: Mar 2006
Posts: 627

Rep: Reputation: 43
libreoffice calc using inverted commas inside concatenate


Hi All,
in libreoffice ( think this might be same in excel ) I need to use inverted commas in a concatenated statement. what I meant by this is I need to add " to the statement so I thought I could do """ however of course it see this as an error, is there something I need to do so I can use " within a statement?

Thanks
 
Old 01-28-2014, 12:10 AM   #2
jdkaye
LQ Guru
 
Registered: Dec 2008
Location: Westgate-on-Sea, Kent, UK
Distribution: Debian Testing Amd64
Posts: 5,465

Rep: Reputation: Disabled
This from the Libreoffice website:
Quote:
You can use the T function. '=T("=A1")' will show as "=A1".
jdk
 
Old 01-29-2014, 02:34 AM   #3
knobby67
Member
 
Registered: Mar 2006
Posts: 627

Original Poster
Rep: Reputation: 43
Thanks I also found the excel 4 " eg """" gives one inverted comma
 
Old 01-30-2014, 12:37 AM   #4
jdkaye
LQ Guru
 
Registered: Dec 2008
Location: Westgate-on-Sea, Kent, UK
Distribution: Debian Testing Amd64
Posts: 5,465

Rep: Reputation: Disabled
If that solves your problem then please mark this thread as "solved" (Thread Tools Menu above the first post of this thread).
Thanks,
jdk
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Absolute value of a column in Libreoffice calc Adwat Linux - Software 5 07-31-2021 03:30 PM
protect/lock a cell in libreoffice calc knobby67 Linux - Software 5 01-11-2015 04:45 AM
[SOLVED] Formula Locking In LibreOffice Calc cin_ Linux - Software 2 11-19-2012 05:12 AM
[SOLVED] libreoffice calc qrange Linux - Software 2 09-13-2012 01:19 AM
Libreoffice Calc - Hyperlink Problems Myrlin Linux - Desktop 6 11-04-2011 06:16 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 02:36 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration