Adding a letter to the start of each cell
 

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

Adding a letter to the start of each cell
 

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.

Colin Hayes wrote:

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

Adding a letter to the start of each cell
 

On Jul 20, 8:04*pm, Dave Peterson wrote:
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.

Colin Hayes wrote:

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

Thanks!

Adding a letter to the start of each cell
 

Thanks!

On Wednesday, August 26, 2009 12:25:21 PM UTC-4, haris wrote:
On Jul 20, 8:04*pm, Dave Peterson wrote:
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.

Colin Hayes wrote:

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

Thanks!

Adding a letter to the start of each cell
 

On Monday, July 20, 2009 7:49:06 PM UTC-5, Colin Hayes wrote:
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

Adding a letter to the start of each cell
 

Thank you :) worked!

Adding a letter to the start of each cell
 

On Monday, 20 July 2009 20:49:06 UTC-4, Colin Hayes wrote:
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