Hello, I need help. I have an excel sheet where I have a cells with values:
TRSMED= 140,000.00
TRSPOT= 20,000.00
TRSMAT= 0.00
I want to know how to convert :
TRSMED to 333990
TRSPOT TO 333991
TRSMAT TO 333992
In order to get:

333990= 140,000.00
333991= 20,000.00
333992= 0.00

I will appreciate all sugetions.

Thank You

Pl

Is TRSMED a single cell or a column of cells? Either way, you can just create a new name with Insert, Name, Define...

However, you cannot create a name that is literally 333990. All range names must start with a letter or an underscore and cannot be a valid A1-style reference, such as D12.

You could just insert a column after your column with TRSMED, TRSPOT, etc.
then in the new column next to TRSMED(Cell A1) put in 333990(Cell B1) and next to TRSPOT(Cell A2) put in 333991(Cell B2). Once you have done this you can highlight Cell B1 and B2 only. Then drag the little black plus sign in the bottom corner of Cell B2 to automatically fill in the sequential numbers.

Hope this helps!

Michael