| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding a letter to the start of each cell
Thank you :) worked!
|
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding letter at the end of cell | Excel Discussion (Misc queries) | |||
| Adding up letter values | Excel Discussion (Misc queries) | |||
| Dificulty adding alphanumeric values either one letter or two | New Users to Excel | |||
| Adding Cells with a letter in one of them | Excel Discussion (Misc queries) | |||
| Adding a number to a letter of the alphabet to get a letter | Excel Worksheet Functions | |||
Linear Mode
