[Solved] Copy only alphabetic characters from cell

[TheOldThug]

I want a cell equal to another cell but I only want the text copied, no numbers. Is this possible to set up? For example the cell to be copied is Timmy 14. However I only want Timmy copied not the number. Cell A1 has Timmy 14. In cell B1 that I am copying A1 into, I am using =A1. However it then copies name and number, don't want number

Edit: Changed subject, was Copy only text from cell  Make your post understandable by others  -- MrProgrammer, forum moderator

[FJCC]

Can you give an example of what you need to do? Is there any pattern to the text and numbers? Are you working with a word followed by numbers or some other consistent pattern?

[TheOldThug]

It is a golf scorecard. The cell has Name and handicap, for example Timmy 14. The other side of the scorecard I want only Timmy copied, not the handicap.

[FJCC]

Judging from your example, we can pull the text that occurs before the first space. A formula for that is

Code: Select all

=LEFT(A1;SEARCH(" ";A1) - 1)

If the names can have spaces in them, like John Andrew, you can pull the text that ends two positions before the first numeric digit.

Code: Select all

=LEFT(A3; SEARCH("\d"; A3) - 2)

For that to work, you have to go to the menu Tools -> Options, expand the OpenOffice Calc list on the left, select Calculate, and select Enable Regular Expressions in Formulas.
If there are cases not covered by those formulas, please provide examples of them.

[Lupp]

For users Of LibreOffice V6.2 or higher and trying to solve similar tasks, I attach an example demonstrating the usage of the REGEX() function for the purpose.

DELorGETpartsofCellStringUsingRegex.ods

(15.59 KiB) Downloaded 74 times

There is some help provided concerning this function and the usage of Regular Expressions generally.
A good tutorial: https://www.regular-expressions.info/
The flavour used By LibO (and AOO where applicable) is the one provided by the ICU.