I need to convert imported data to plain English. In one column there are
rows containing one of four values (either A,B, C or D), which I want to
replace with their descriptors (Spring, Summer, Autumn, Winter).

Highlight the column and CTRL-H (Find & Replace), then:

Find What: A
Replace With: Spring
Click Replace All

With the range still highlighted, do CTRL-H again, and:

Find What: B
Replace With: Summer
Click Replace All

and again to change C into Autumn, and finally to change D into
Winter.

Hope this helps.

Pete

On Oct 24, 10:59 pm, Geordie
wrote:
I need to convert imported data to plain English. In one column there are
rows containing one of four values (either A,B, C or D), which I want to
replace with their descriptors (Spring, Summer, Autumn, Winter).

Thanks, but I'm looking for a quicker way, like a formula I can use that
would substitute all values at once.

"Pete_UK" wrote:

Highlight the column and CTRL-H (Find & Replace), then:

Find What: A
Replace With: Spring
Click Replace All

With the range still highlighted, do CTRL-H again, and:

Find What: B
Replace With: Summer
Click Replace All

and again to change C into Autumn, and finally to change D into
Winter.

Hope this helps.

Pete

On Oct 24, 10:59 pm, Geordie
wrote:
I need to convert imported data to plain English. In one column there are
rows containing one of four values (either A,B, C or D), which I want to
replace with their descriptors (Spring, Summer, Autumn, Winter).

You should post your layout. Are you really saying A,B,C,D or is it
something else. Whole word in cell or part of a string? etc.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Geordie" wrote in message
...
I need to convert imported data to plain English. In one column there are
rows containing one of four values (either A,B, C or D), which I want to
replace with their descriptors (Spring, Summer, Autumn, Winter).

I have a column with various values in random order, e.g,:
A
B
A
D
C
B
etc (for another 300 rows).
I want to replace each letter with a word (A to equal "Spring", B to equal
"Summer", C to equal "Autumn", D to equal "Winter"). I'm looking for a
formula which will do this in one step, rather than using find & replace.
This is raw data which i want to convert to use in a mailmerge.

"Don Guillett" wrote:

You should post your layout. Are you really saying A,B,C,D or is it
something else. Whole word in cell or part of a string? etc.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Geordie" wrote in message
...
I need to convert imported data to plain English. In one column there are
rows containing one of four values (either A,B, C or D), which I want to
replace with their descriptors (Spring, Summer, Autumn, Winter).

In an adjacent column enter this formula and drag/copy down.

=LOOKUP(A1,{"A","B","C","D"},{"Spring","Summer","A utumn","Winter"})


Gord Dibben MS Excel MVP

On Wed, 24 Oct 2007 14:59:00 -0700, Geordie
wrote:

I need to convert imported data to plain English. In one column there are
rows containing one of four values (either A,B, C or D), which I want to
replace with their descriptors (Spring, Summer, Autumn, Winter).

On Oct 24, 6:37 pm, Gord Dibben <gorddibbATshawDOTca wrote:
In an adjacent column enter this formula and drag/copy down.

=LOOKUP(A1,{"A","B","C","D"},{"Spring","Summer","A utumn","Winter"})

Gord Dibben MS Excel MVP

On Wed, 24 Oct 2007 14:59:00 -0700, Geordie
wrote:



I need to convert imported data to plain English. In one column there are
rows containing one of four values (either A,B, C or D), which I want to
replace with their descriptors (Spring, Summer, Autumn, Winter).- Hide quoted text -

- Show quoted text -

IF YOU TAKE GORD DIBBEN'S FORMULA AND EXPAND IT TO THE FOLLOWING IF
STATEMENT IT WILL ERROR TRAP ANY LETTERS GREATER THAN D GIVING A BLANK
CELL INSTEAD OF "WINTER"

=IF(A1"D","",LOOKUP(A1,{"A","B","C","D"},
{"Spring","Summer","Autumn","Winter"}))

HOPE THIS HELPS

that does the trick superbly. Thanks, really appreciated.

"BIG D" wrote:

On Oct 24, 6:37 pm, Gord Dibben <gorddibbATshawDOTca wrote:
In an adjacent column enter this formula and drag/copy down.

=LOOKUP(A1,{"A","B","C","D"},{"Spring","Summer","A utumn","Winter"})

Gord Dibben MS Excel MVP

On Wed, 24 Oct 2007 14:59:00 -0700, Geordie
wrote:



I need to convert imported data to plain English. In one column there are
rows containing one of four values (either A,B, C or D), which I want to
replace with their descriptors (Spring, Summer, Autumn, Winter).- Hide quoted text -

- Show quoted text -

IF YOU TAKE GORD DIBBEN'S FORMULA AND EXPAND IT TO THE FOLLOWING IF
STATEMENT IT WILL ERROR TRAP ANY LETTERS GREATER THAN D GIVING A BLANK
CELL INSTEAD OF "WINTER"

=IF(A1"D","",LOOKUP(A1,{"A","B","C","D"},
{"Spring","Summer","Autumn","Winter"}))

HOPE THIS HELPS

Good point Big D


Gord

On Wed, 24 Oct 2007 18:53:28 -0700, BIG D wrote:

On Oct 24, 6:37 pm, Gord Dibben <gorddibbATshawDOTca wrote:
In an adjacent column enter this formula and drag/copy down.

=LOOKUP(A1,{"A","B","C","D"},{"Spring","Summer","A utumn","Winter"})

Gord Dibben MS Excel MVP

On Wed, 24 Oct 2007 14:59:00 -0700, Geordie
wrote:



I need to convert imported data to plain English. In one column there are
rows containing one of four values (either A,B, C or D), which I want to
replace with their descriptors (Spring, Summer, Autumn, Winter).- Hide quoted text -

- Show quoted text -

IF YOU TAKE GORD DIBBEN'S FORMULA AND EXPAND IT TO THE FOLLOWING IF
STATEMENT IT WILL ERROR TRAP ANY LETTERS GREATER THAN D GIVING A BLANK
CELL INSTEAD OF "WINTER"

=IF(A1"D","",LOOKUP(A1,{"A","B","C","D"},
{"Spring","Summer","Autumn","Winter"}))

HOPE THIS HELPS