Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Any help in manipulating text appreciated
HI, I need to be able to check cell contents in a specific row (c) and se if the text matches and if it does the put different text in different cell. eg if a3="text" then a5="different text" the information in a3 could be up to 15 different items resulting in u to 6 different texts. something like search and replace only replacing to a differen multiple cells 1 or 2 cells away, throughout the worksheet. Is this possible -- Ron ----------------------------------------------------------------------- Ronl's Profile: http://www.excelforum.com/member.php...fo&userid=1592 View this thread: http://www.excelforum.com/showthread.php?threadid=27409 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Any help in manipulating text appreciated
On Mon, 1 Nov 2004 01:05:00 -0600, Ronl
wrote: HI, I need to be able to check cell contents in a specific row (c) and see if the text matches and if it does the put different text in a different cell. eg if a3="text" then a5="different text" the information in a3 could be up to 15 different items resulting in up to 6 different texts. something like search and replace only replacing to a different multiple cells 1 or 2 cells away, throughout the worksheet. Is this possible? Sounds like a job for a lookup table. Check HELP for VLOOKUP. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Your Help is Appreciated | Charts and Charting in Excel | |||
Manipulating Text to create HLOOKUP | Excel Worksheet Functions | |||
Help with manipulating text in Excel 2003 | Excel Discussion (Misc queries) | |||
Manipulating Text between sheets, in a workbook | Excel Discussion (Misc queries) | |||
Manipulating text - 2 queries | Excel Programming |