LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 9
Default Count Word in long string

Dears

I want to count how many specific word is repeted in long string in one cell i will give you example

Red , green , red , blue , ,black ,green , red, red,

what i want to do is to count how many times the word red repeted starting from the right hand side till the fourth coma only not through the whole sting only till the fourth coma
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
String-in-Cell .... too long??? Word Wrap not working...PLEASE HE Steve P[_2_] Excel Discussion (Misc queries) 3 February 19th 10 09:14 PM
Importing Long String - String Manipulation (INVRPT) (EDI EANCOM 96a) Brian Excel Programming 3 February 9th 06 03:38 PM
Importing Long String - String Manipulation (EDI EANCOM 96a) Brian Excel Programming 6 February 9th 06 12:27 PM
From String to Long MD Excel Programming 3 June 6th 05 04:44 PM
Get long value for a date string jerry chapman[_2_] Excel Programming 4 February 22nd 05 11:06 PM


All times are GMT +1. The time now is 06:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"