| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding characters in excel column
Lets assume the numbers are in column A
Then in column B type ="BP"&A1 Then copy down If its only for display, and you don't actually need the letters in any calculations. Try adjusting the cell number format Format Cells Number then Select custom Type the following "BP"0 George rita wrote: I would like to know how to add a character in front of the #s(each row is different #) in a column on excel? for example: 15070 to BP15070 15093 to BP15093, etc. Please advise. rita |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What is Excel keyboard shortcut for adding column? | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Multiply two columns in Excel or one column by one number | New Users to Excel | |||
| Adding Column in an Excel Sheet by Command | Excel Worksheet Functions | |||
| Remove 1st 3 characters in each field of Excel column | Excel Worksheet Functions | |||
Threaded Mode
