| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding alpha-numeric value in from all alphabetic content in a col
I asked similar question for numbers a day ago and it was resolved
This time I need to add alpha numeric value (say 08FG55) in front of all the contents of a partucular column(say D). And The current content of column D are only alalphabetic content , no numbers. How do I do it? -- capxc |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding alpha-numeric value in from all alphabetic content in acol
="08FG55"&D1
then copy down |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding alpha-numeric value in from all alphabetic content in a
Do I put this command in format cell?
How to copy down? Sorry , I am not very techie. Please give me some lights. Sincerely, -- capxc "Jarek Kujawa" wrote: ="08FG55"&D1 then copy down |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding alpha-numeric value in from all alphabetic content in a
You'll have to write this formula Jarek gave you in a new column and then
copy the formula down the length of your data set. -- Tips for Excel, Word, PowerPoint and Other Applications http://www.kan.org/tips "capxc" wrote: Do I put this command in format cell? How to copy down? Sorry , I am not very techie. Please give me some lights. Sincerely, -- capxc "Jarek Kujawa" wrote: ="08FG55"&D1 then copy down |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to add the same alpha-numeric value to all the content of a co | Excel Discussion (Misc queries) | |||
| formula adding range of cells that contains alpha numeric | Excel Worksheet Functions | |||
| adding zero th alpha numeric value | Excel Discussion (Misc queries) | |||
| The colums changed from alpha to numeric how do you make it alpha | Excel Discussion (Misc queries) | |||
| Calculating on alphabetic cell content | New Users to Excel | |||
Linear Mode
