| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy only the digits from a cell
Hi group,
In a cell I have written first a text, then a space, and finally some digits (between 3 and 5) Is it possible, with the help of a formula or a macro, to copy only the digits to a new cell? Regards, Kaj Pedersen |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy only the digits from a cell
does "a text" mean a single character, so that the numbers always start as
the third letter in the string =Right(A1,len(a1)-2) If not, you will need to use the find command to fine the space. =RIGHT(A1,LEN(A1)-FIND(" ",A1)) -- Regards, Tom Ogilvy Kaj Pedersen wrote in message ... Hi group, In a cell I have written first a text, then a space, and finally some digits (between 3 and 5) Is it possible, with the help of a formula or a macro, to copy only the digits to a new cell? Regards, Kaj Pedersen |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy only the digits from a cell
Hi Tom,
The FIND command was exactly what I needed. Thanks for your help. Regards Kaj Pedersen "Tom Ogilvy" skrev i en meddelelse ... does "a text" mean a single character, so that the numbers always start as the third letter in the string =Right(A1,len(a1)-2) If not, you will need to use the find command to fine the space. =RIGHT(A1,LEN(A1)-FIND(" ",A1)) -- Regards, Tom Ogilvy Kaj Pedersen wrote in message ... Hi group, In a cell I have written first a text, then a space, and finally some digits (between 3 and 5) Is it possible, with the help of a formula or a macro, to copy only the digits to a new cell? Regards, Kaj Pedersen |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA write macro change column with 3 number digits to 4 digits the | Excel Discussion (Misc queries) | |||
| Sort by even and odd digits and copy to separate worksheet | Excel Worksheet Functions | |||
| Copy middle digits from one cell into another | Excel Worksheet Functions | |||
| copy middle digits from one cell into another | Excel Discussion (Misc queries) | |||
| copy, insert and add digits | Excel Worksheet Functions | |||
Linear Mode
