Macro in Excel

[computerman29651]

Does anyone know how to create a macro or some other way to change the appearance of text in a cell?

For example:

Original:

12HGT-T

Changed To:

12hGT-T

 

[mintjulep]

So would you like:

All capitol H changed to lower-case h?

Any instance of "HGT" changed to "hGT"?

The third character changed from capitol to lower-case?

The case of the third character changed to whatever is isn't originally?

The first text character changed from capitol to lower-case?

The case of the first text character changed to whatever is isn't originally?

Or one of the many many other possible things that could be represented by your example?

 

[computerman29651]

I would like the third character changed to lower-case.

 

[SkipVought]

Use the MID function.

Skip,

_[red][/red]

 

[Gavona]

Other functions to use along with MID are LOWER and REPLACE.


Gavin

 

[KenWright]

=LEFT(A1,2)&LOWER(MID(A1,3,1))&RIGHT(A1,LEN(A1)-3)

Regards
Ken............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------