Replace a letter with a word

**jaywizz** · 08-10-2009, 06:28 AM

Column A has cells showing either Y or N I want Column B to take a Y and convert it to a Yes and N to No

I tried an IF statement but it wont seem to work.

Thanks

**Cheeky Charlie** · 08-10-2009, 06:31 AM

=LOOKUP(A1,{"N","Y"},{"No","Yes"})

or, perhaps more sensibly... use find and replace (Ctrl +H) Find 'Y', replace with 'Yes', replace all et sim. for No

HTH

**jaywizz** · 08-10-2009, 06:43 AM

Thanks for that. I just want to import data each week into some colums and run a pivot chart off of the static columns that are reading the imported data.

I have added to your Rep.

Replace a letter with a word

LinkBack

Thread Tools

Rate This Thread

Display

Replace a letter with a word

Re: Replace a letter with a word

Re: Replace a letter with a word

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions