Menu

Can I create an If Statement that will replace text

Search this Thread

Prev

Previous Post

Next Post

Next

#5

Report Post

Posted to microsoft.public.excel.worksheet.functions

Don Guillett

Posts: n/a

Default

Can I create an If Statement that will replace text

glad it helped

--
Don Guillett
SalesAid Software

"kalikw" wrote in message
...
It worked! Thanks so much Bob and Don for your help.

"Don Guillett" wrote:

try putting quotes around the text

--
Don Guillett
SalesAid Software

"kalikw" wrote in message
...
Can I create an If statement that will replace text with text. For
example
can I write a statement that will do this
If(F1=MJW, RGS, JDC).
I have tried to use the text function and subsitute function but it is
not
working. Any helps or tips would be appreciated.

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
How change dimensions of data label text box in pie chart?	Gouden Willem	Charts and Charting in Excel	3	March 7th 06 12:11 PM
how to create automatic macro with if statement or similar	betatryck_se	Excel Discussion (Misc queries)	2	December 14th 05 11:32 AM
replace axis text with graphics on excel chart (excel 2003)	Mad_Hatter_29	Charts and Charting in Excel	3	December 6th 05 01:42 PM
Find and replace should work in Excel text boxes	Bob@Teton	Excel Discussion (Misc queries)	0	October 20th 05 01:16 PM
Replace ALT+ENTER from multiple text cell	Johnd	Excel Discussion (Misc queries)	1	February 11th 05 10:57 AM

All times are GMT +1. The time now is 06:32 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement