Convert unknown type to numeric and text

[ExcelUser2707]

HI ALL,

I have data with numeric & text filed, but it’s showed as count base. (Not calculable at the base of formula)

Beginning space is also there, I used TRIM function to clear the same, but negative result.

I can’t use this type of data directly at pivot.

Any suggestion, to convert this filed as numeric and text?

Thanks in advance

Please find attached sample sheet.

[martindwilson]

try putting =char(160) in a spare cell it looks blank dont worry copy that cell
select colums b:c
use find/replace
in find use ctrl+v to paste in the value you copied leave replace blank
then replace all

[ExcelUser2707]

HI MARTINDWILSON,

It working, no no no ….Running ….

It is working very well, with the help of your suggested formula / trick.

Thanks a lot, for your kindly support and assistance

God bless you