Formula

C

Cazumel

Hi

I have the following situation:
94101 How do i add a (.) ( Period at the end of each number in each Cell)
94101
94101
93001
93001
 
G

Gord Dibben

In a helper column enter

=cellref & "."

Copy down then paste special as value.


Gord Dibben MS Excel MVP
 
C

Cazumel

Thank you so much
Have a nice day

Gord Dibben said:
In a helper column enter

=cellref & "."

Copy down then paste special as value.


Gord Dibben MS Excel MVP
Click to expand...
 
Top