Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove text
In 07, how do I remove text from a cell. Currently reads "Phone:
123-123-1234" and would like to remove the "Phone:" part. I tried =RIGHT(M2,14) but some have extensions. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove text
Tim,
Assuming no space after the colon, use =mid(M2,7,25) to get only the phone number. change the 7 to an 8 if there is a space after the colon -- hope to help, cm "Tim" wrote: In 07, how do I remove text from a cell. Currently reads "Phone: 123-123-1234" and would like to remove the "Phone:" part. I tried =RIGHT(M2,14) but some have extensions. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove text
For a formula solution, look in the help index for SUBSTITUTE
-- Don Guillett Microsoft MVP Excel SalesAid Software "Tim" wrote in message ... In 07, how do I remove text from a cell. Currently reads "Phone: 123-123-1234" and would like to remove the "Phone:" part. I tried =RIGHT(M2,14) but some have extensions. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove text
Hi
=TRIM(RIGHT(M2,LEN(M2)-6)) the 6 assume Phone: or 6 characters Mike "Tim" wrote: In 07, how do I remove text from a cell. Currently reads "Phone: 123-123-1234" and would like to remove the "Phone:" part. I tried =RIGHT(M2,14) but some have extensions. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove text
Hi Tim
Try Text to Column..in Office 2007 - - Insert a new blank column after the column with phone numbers - Select the entire column containing the phone numbers - press Alt + D + E - Delimited - Other - Colon (:) - Finish This will remove the word phone from the column. Thanks Om "Tim" wrote: In 07, how do I remove text from a cell. Currently reads "Phone: 123-123-1234" and would like to remove the "Phone:" part. I tried =RIGHT(M2,14) but some have extensions. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text - Remove text Item No.99 (First 2 Chars) and move to end | Excel Discussion (Misc queries) | |||
Easiest way to remove text from a cell that has text and numbers? | Excel Discussion (Misc queries) | |||
Filter text in a column by its Indent, to remove certain text | Excel Discussion (Misc queries) | |||
want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions |