If B3="TEXT" then replace C3 with "TEXT"

**Unlimited007** · 10-07-2019, 02:42 PM

I am working on a CSV document and as far as I understand I cant use formulas in the cells.
I have a sheet where I would need to use the replace function in a certain way but im unsure of how. Lets see if I can explain it in an understandable way.
If there is a text "EGKK" in column B then replace column C at the same row as where "EGKK" was found with "London Gatwick".
I have a hard time beleiving there is a function capable of this but I have to ask as doing it manually would take a long time.

**63falcondude** · 10-07-2019, 02:47 PM

Hello and welcome to the forum.

If it's in Excel, you can use formulas.

In a blank column, let's say in row 2 of column D, Enter this:
=IF(B2="EGKK","London Gatwick",C2)
Copy the formula down the entire column.

Now copy column D and paste as values into column C.

You can now delete column D.

**Richard Buttrey** · 10-07-2019, 02:48 PM

Hi,

You will of course need a table of ICAO airport codes with the code in the first column and the decription in the second column.
Name the two column range of cells as say "ICAO"

Then in C1 copied down use

Formula:

Please Login or Register  to view this content.

**samba_ravi** · 10-07-2019, 02:58 PM

do the following
1) Use Data Filters at Column Headers
2) Filter Data in Column B (Select "EGKK" for Filters)
3) Then Change the Text in Column C for 1 time in the same row
4) Then copy the text (Ctrl+C) which you entered in Column C
5)Then Select Column C (From Top to Bottom the after filter data in Column B)
6) Then Press Ctrl+G (Go to) > click on Special Button > Select Visible Cells only > OK
7) Then Paste (Ctrl+V) the copied data

**Unlimited007** · 10-07-2019, 02:59 PM

Thanks, I think this might work.

**Richard Buttrey** · 10-07-2019, 03:07 PM

Do we presume that you only want to change the EGKK Gatwick codes or does your csv file contain many airport codes that need changing?

**menem** · 10-07-2019, 08:11 PM

I think Richard's solution is the best way.
By the way, you need no to save back to .csv file format.
I mean you can save in excel format for the purpose (text replace)
like 1 sheet for copy .csv in and the other sheet for output of .csv
(By any formula in them)
By this way, you can convert it again and again later.

Regards.

If B3="TEXT" then replace C3 with "TEXT"

LinkBack

Thread Tools

Rate This Thread

Display

If B3="TEXT" then replace C3 with "TEXT"

Re: If B3="TEXT" then replace C3 with "TEXT"

Re: If B3="TEXT" then replace C3 with "TEXT"

Re: If B3="TEXT" then replace C3 with "TEXT"

Re: If B3="TEXT" then replace C3 with "TEXT"

Re: If B3="TEXT" then replace C3 with "TEXT"

Re: If B3="TEXT" then replace C3 with "TEXT"

Thread Information

Users Browsing this Thread

Similar Threads

Replace "ActiveSheet.Pictures.Insert" with "Shapes.Addpicture" and "SaveWithDocument"

What's wrong with my this formula "=CELL("contents","D" & TEXT(MATCH(MIN(M25:M39),M25:M39"

create text string: "NOT "[b2value]", NOT "[b3value]", ..., NOT "[b600value]"

Date format of just "st" "nd" "rd" and "th" with text included

[SOLVED] If there is any text in column "A$" on "sheet1" then move cell to column "A$" on "sheet2"

How can i copy value from "HTMLText"(EMBED("Forms.HTML:Text","")),using Macro

Replace numbers with Text ("1" to "Apple", for example)

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions