LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
GD GD is offline
external usenet poster
 
Posts: 83
Default IF forumla to standardise text

I'm looking for a formula to do the following,,

Look at column A (cells 1-100) which is populated with text, with 3 or 4
variances of the same output, e.g "ceilings" "cielings" "clings" - i'd need
the formula to take this range into account and pick up all results with
"ings" in it, and report standard result of "Result Ceilings" for each cell
in A1-A100 with any text arrangement of "ings" in it

Can this be done?
 
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
if then forumla Ann Excel Worksheet Functions 2 June 26th 07 01:50 AM
Add forumla Ross Excel Discussion (Misc queries) 1 April 3rd 07 10:00 AM
Forgotten a Simple Forumla - Is Text present in another column samprince Excel Discussion (Misc queries) 3 August 4th 06 04:22 PM
Forumla to recognize text Woody13 Excel Discussion (Misc queries) 2 January 24th 06 04:17 PM
Forumla Don Excel Worksheet Functions 3 August 9th 05 02:52 AM


All times are GMT +1. The time now is 11:17 AM.

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"