Hello,
In A1 I have the following text :
ABCD#12345#5abc2
My goal is to have all the characters after # shown in B1, so
12345#5abc2
Due to the presence of a second "#" in A1, I'm currently unable to solve it with FIND, RIGHT, and LEFT functions. Is there a way to solve this?
Best regards and thanking you in advance for your time,
Sura
[Solved] Help with Find, Right, and Left functions
[Solved] Help with Find, Right, and Left functions
Last edited by sura on Fri Jan 05, 2024 7:50 pm, edited 1 time in total.
OpenOffice 3.1 on Windows Vista
Re: Help with Find, Right, and Left functions
Does
work for you?
Code: Select all
=MID(A1;FIND("#";A1)+1;LEN(A1))OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: Help with Find, Right, and Left functions
Find, Len, Right:I'm currently unable to solve it with FIND, RIGHT, and LEFT functions.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: Help with Find, Right, and Left functions
So clever.
Thank you, both of you!
Thank you, both of you!
OpenOffice 3.1 on Windows Vista
Re: [Solved] Help with Find, Right, and Left functions
(For users of more recent versions:)
Many tasks of the kind have compact solutions based on the usage of the REGEX() function. However, this function is only available in LibreOffice V 6.2 or higher, and such LibO, if run under Windows(TM), will require Win 7 or higher.
See examples:
Many tasks of the kind have compact solutions based on the usage of the REGEX() function. However, this function is only available in LibreOffice V 6.2 or higher, and such LibO, if run under Windows(TM), will require Win 7 or higher.
See examples:
On Windows 10: LibreOffice 24.2 (new numbering) and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
---
Lupp from München