Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF forumla to standardise text
Try this in B1:
=IF(ISNUMBER(SEARCH("ings",A1)),"Result Ceilings",A1) then copy down to B100. Hope this helps. Pete On Oct 10, 9:55*am, GD wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if then forumla | Excel Worksheet Functions | |||
Add forumla | Excel Discussion (Misc queries) | |||
Forgotten a Simple Forumla - Is Text present in another column | Excel Discussion (Misc queries) | |||
Forumla to recognize text | Excel Discussion (Misc queries) | |||
Forumla | Excel Worksheet Functions |