Tech help

[eenglish]

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?

 

[Gord Dibben]

Data>Text to Columns?

See help on RIGHT function?

Post a few examples?


Gord

 

[Don Guillett]

Data>Text to Columns?

See help on RIGHT function?

Post a few examples?

Gord

correct for word wrap

'=RIGHT(A1,LEN(A1)-SEARCH("@",SUBSTITUTE(A1," ","@",LEN(A1)-
LEN(SUBSTITUTE(A1," ","")))))