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?

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?

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," ","")))))