Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Add Text To Multiple cells
I am working on this project & I cant figure out how to add a letter in front
of each number in a cell without clicking in to each individual cell and typing it in. (very time consuming and tedious) The problem is - it's not all the cells but a majority, all of the numbers are in the same column. To explain, these are documents in storage. Each item is assigned a number (not in any particular numerical order but they have to stay in the order they are. Example: X39655 X39656 X39711 39662 39664 39665 The last three numbers need the X in front of them. Any ideas? Thanks so much!! |
#3
|
|||
|
|||
Add a "helper" column containing a text formula which will add your "X".
Then, you can delete the underlying formula in this helper column, leaving the revised text behind. You could then delete the original, if desired. With data starting in A1, enter this in B1: =IF(LEFT(A1)="X",A1,"X"&A1) Then, drag down to copy, using the "fill handle", OR *Double click* the fill handle, to copy the formula in B1 down Column B, as far as there is data in Column A. Now, while the cells in Column B are *still* selected from the "copy", to delete the formula, and leave the data behind: Right click in the selection and choose "Copy". Right click again, and choose "Paste Special". Click in "Values", then <OK, then <Esc. You could now delete the original data if you wish. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "nmodafferi" wrote in message ... I am working on this project & I cant figure out how to add a letter in front of each number in a cell without clicking in to each individual cell and typing it in. (very time consuming and tedious) The problem is - it's not all the cells but a majority, all of the numbers are in the same column. To explain, these are documents in storage. Each item is assigned a number (not in any particular numerical order but they have to stay in the order they are. Example: X39655 X39656 X39711 39662 39664 39665 The last three numbers need the X in front of them. Any ideas? Thanks so much!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help importing text files into individual cells | Excel Discussion (Misc queries) | |||
Combining & formatting cells with text - Excel 2002 | Excel Discussion (Misc queries) | |||
I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
Adding two text cells together | Excel Discussion (Misc queries) | |||
Format text across cells | New Users to Excel |