| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to extract just text from cells
Hi all,
I want to extract only TEXT from a column of numbers and text. For example: WHAT I HAVE: 150mgdl 2000mg 10mgdl 500cc WHAT I WANT: mgdl mg mgdl cc is there a function in Excel that does this and extracts only the text, not the numbers? Thanks everyone! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to extract just text from cells
Try this:
=MID(A15,SUMPRODUCT(--ISNUMBER(--MID(A1,ROW($1:$999),1)))+1,999) Regards, Ryan-- -- RyGuy "Access Joe" wrote: Hi all, I want to extract only TEXT from a column of numbers and text. For example: WHAT I HAVE: 150mgdl 2000mg 10mgdl 500cc WHAT I WANT: mgdl mg mgdl cc is there a function in Excel that does this and extracts only the text, not the numbers? Thanks everyone! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to extract just text from cells
This shoudl work as well:
Function RemDigits(str As String) As String Dim re As Object Set re = CreateObject("vbscript.regexp") re.Global = True re.Pattern = "\d+" RemDigits = re.Replace(str, "") End Function Regards, Ryan-- -- RyGuy "Access Joe" wrote: Hi all, I want to extract only TEXT from a column of numbers and text. For example: WHAT I HAVE: 150mgdl 2000mg 10mgdl 500cc WHAT I WANT: mgdl mg mgdl cc is there a function in Excel that does this and extracts only the text, not the numbers? Thanks everyone! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to extract just text from cells
PERFECT - THANKS!
"ryguy7272" wrote: Try this: =MID(A15,SUMPRODUCT(--ISNUMBER(--MID(A1,ROW($1:$999),1)))+1,999) Regards, Ryan-- -- RyGuy "Access Joe" wrote: Hi all, I want to extract only TEXT from a column of numbers and text. For example: WHAT I HAVE: 150mgdl 2000mg 10mgdl 500cc WHAT I WANT: mgdl mg mgdl cc is there a function in Excel that does this and extracts only the text, not the numbers? Thanks everyone! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to extract just text from cells
If that was helpful, click 'Yes' to indicate that!!
Thanks, Ryan-- -- RyGuy "ryguy7272" wrote: This shoudl work as well: Function RemDigits(str As String) As String Dim re As Object Set re = CreateObject("vbscript.regexp") re.Global = True re.Pattern = "\d+" RemDigits = re.Replace(str, "") End Function Regards, Ryan-- -- RyGuy "Access Joe" wrote: Hi all, I want to extract only TEXT from a column of numbers and text. For example: WHAT I HAVE: 150mgdl 2000mg 10mgdl 500cc WHAT I WANT: mgdl mg mgdl cc is there a function in Excel that does this and extracts only the text, not the numbers? Thanks everyone! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to extract certain text from text string | Excel Worksheet Functions | |||
| Extract text from large Text | Excel Discussion (Misc queries) | |||
| Text Extract | Excel Worksheet Functions | |||
| EXTRACT TEXT FROM TEXT STRING | Excel Worksheet Functions | |||
| Extract text | Excel Worksheet Functions | |||
Linear Mode
