| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tech help
I have a list of over a hundred tv channels that shows for each
channel a text description followed by a channel number. How can I extract the channel number and place it in the adjoining cell for every listing? Is this possible? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Tech help
DataText to Columns?
See help on RIGHT function? Post a few examples? Gord On Mon, 21 Nov 2011 14:44:49 -0800 (PST), " wrote: I have a list of over a hundred tv channels that shows for each channel a text description followed by a channel number. How can I extract the channel number and place it in the adjoining cell for every listing? Is this possible? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Tech help
On Nov 21, 5:02*pm, Gord Dibben wrote:
DataText to Columns? See help on RIGHT function? Post a few examples? Gord On Mon, 21 Nov 2011 14:44:49 -0800 (PST), " wrote: I have a list of over a hundred tv channels that shows for each channel a text description followed by a channel number. How can I extract the channel number and place it in the adjoining cell for every listing? Is this possible? correct for word wrap '=RIGHT(A1,LEN(A1)-SEARCH("@",SUBSTITUTE(A1," ","@",LEN(A1)- LEN(SUBSTITUTE(A1," ",""))))) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mainframe Tech Blog | Excel Discussion (Misc queries) | |||
| Excel VBA tech interview | Excel Programming | |||
| coding tech | Excel Programming | |||
| TECH SUPPORT NUMBERS | New Users to Excel | |||
| High Tech Question ? | Excel Programming | |||
Hybrid Mode
