Adding a letter to the start of each cell

[Colin Hayes]

Hi

I have a series of numbers in column A. I need to add the letter B to
the beginning of each.

Can someone suggest some code to achieve this?


Grateful for any help.


Best Wishes

 

[Dave Peterson]

Maybe you could use a helper column that would do the work for you:

="B"&A1
or
="B"&text(a1,"00000")
if you had some sort of special format.

Then you could drag that formula down as far as you need (to match column A).

Then select that column B:
Edit|Copy
select column A
Edit|paste special|values

And delete that helper column.

 

[haris]

Maybe you could use a helper column that would do the work for you:

="B"&A1
or
="B"&text(a1,"00000")
if you had some sort of special format.

Then you could drag that formula down as far as you need (to match columnA).

Then select that column B:
Edit|Copy
select column A
Edit|paste special|values

And delete that helper column.

Thanks!

 

[sherell.fuller]

Thanks!

Thanks!

 

[Don Guillett]

Hi

I have a series of numbers in column A. I need to add the letter B to
the beginning of each.

Can someone suggest some code to achieve this?


Grateful for any help.


Best Wishes

or a custom format

 

[habhoubis]

Thank you worked!

 

[cadel89]

Hi

I have a series of numbers in column A. I need to add the letter B to
the beginning of each.

Can someone suggest some code to achieve this?


Grateful for any help.


Best Wishes