Tech help

  • Thread starter Thread starter eenglish
  • Start date Start date
E

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?
 
Data>Text to Columns?

See help on RIGHT function?

Post a few examples?

Gord
Click to expand...
correct for word wrap

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