PDA

View Full Version : Convert format cell to text



naris
06-26-2012, 02:02 AM
Dear All Excel Expert,

Please help me to solve my problem ! :banghead: :help

I have example file attached, I want in column "E:E" will filling with the format cell of the cell from column "C:C".
Example in cell "E2" --> PCE same as format cell in cell "C2" with "PCE" format.

Thanks in advance for your help !..

Best regards,
Naris

Bob Phillips
06-26-2012, 03:04 AM
You could use a UDF such as

Function GetSpecialFormat(rng As Range) As String
GetSpecialFormat = Trim(Replace(rng.Text, rng.Value, ""))
End Function


=GetSpecialFormat(C2)

naris
06-26-2012, 03:13 AM
Dear Mrs/Mr. xld,

Thanks you very much for your great help !! :clap:
My problem solved !.

Best regards,
Naris