| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how to add a letter to front of column sample ID
I have an excel spreadsheet consisting of columns of "patient ID's" and then various columns of "numerical values".
Some patient ID's are "DD-0002-0001PK" as an example. I Want to add a "L" to some of those sample names....like "DD-0002-001PK-L" how can I do that? I can't just put ="L"&A1, because my values are text and if I do that it just changes it to a 0, and I need those ID labels, but I don't want to have to go back manually and type in "L". Is there anyway that I can put "L" on the back of the first 40 ID's? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert a letter in front of number in every cell? | Excel Worksheet Functions | |||
| I WANT TO INSERT A LETTER IN FRONT OF A NUMBERS | Excel Worksheet Functions | |||
| How to replace column letter in refferences with a function using the old column letter? | Links and Linking in Excel | |||
| How to replace column letter in refferences with a function using the old column letter? | Excel Worksheet Functions | |||
| how to add a letter in front of each number in a cell | Excel Discussion (Misc queries) | |||
Threaded Mode
