Add/subract the same value to every line in a column

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

I want to add '0 to every line of a list in a column. I
think there might be a easy way to do it.

For example:
row B
34
35
36
37


Wanted Result
'034
'035
'036
'037

Along the same lines, I have a column with same number
starting each row that I want to get rid of.

Start with:
05000US08001
05000US08003
05000US08005
05000US08007
05000US08009
05000US08011


Wanted Result:
'001
'005
'007
'009
'011


Help would be appreciated.
Alex
 
Not sure, but here are two ways.

For 34 to 034 just use cell format to make the number fit the mask 000

For 34 to '034 you could do the same using "'"000 or use =+"'0"&D1
where D16 is 34

The latter is called concatenation and the & is just a shorthand fo
the full name
 
Hi
one way:
format the cells with the custom format
000

or use the formula
=TEXT(A1,"000")

for your second question you may use
=RIGHT(A1,3)
 
Back
Top