Add some word to all or some rows in Excel

Question

If I want to add some word before each number of a column  how can I do that    10 s 123  24 c 235  33 s 345  46 s 346  59 s 546  62 c 277   I mean   for example I put the word  k  before each number in the first column and get  k10 s 123  k24 c 235  k33 s 345  k46 s 346  k59 s 546  k62 c 277

User · Answer

Insert a column left to the column in question adding column A beside column B   Provide the value you want to append in 1st cell of column A Insert a column right to the column in question   column C  Add this formula -   CONCATENATE  A1   B1   Drag it down to apply to all values in column You will find concatenated values in column C   This worked for me

User · Answer

Following Mike s answer  I d also add another step  Let s imagine you have your data in column A    Insert a column with the word you want to add  column B  with k  apply the formula  as suggested by Mike  that merges both values in column C  C1 A1 B1  Copy down the formula Copy the values in column C  already merged  Paste special as  values  Remove columns A and B   Hope it helps   Ofc  if the word you want to add will always be the same  you won t need a column B  thus  C1  k  A1   Rgds

User · Answer

Select All cells that want to change  right click and select Format  cell  In category select Custom  In Type select General and  insert this formol ----   k

User · Answer

Save a copy of your spreadsheet first  just in case     Insert two new columns to the left of the numbered column   Put a k in the first row of the first  new  column   Copy it  the k    Go to the original first column  now the third column  and leave your cursor on the first row that has data  Hit ctrl and down arrow  at the same time  to jump to the bottom of the populated data range for your original first column    Left arrow twice to get to the new first column  the one with a k at the very top   Hit Ctrl-shift-up arrow to go to the first cell with data populated  the original k you put in   highlighting all the cells in-between your starting and ending point   Use paste  ctrl-v  right-click or whatever your preferred method   and it ll fill all those cells with a k  Then use the  Concatenate  formula in the second column  Its two arguments will be the column of Ks  column A  first column  and the column with the numbers in it   This will get you a column with the results of the K column and your numbers    Hope this helps  The ctrl-shift-arrow and ctrl-arrow shortcuts are amazing for working with large datasets in Excel

User · Answer

Insert a column  for instance a new A column   Then use this function     k  amp B1  and copy it down   Then you can hide the new column A if you need too

[excel] Add some word to all or some rows in Excel?

Examples related to excel

Examples related to edit

Examples related to rows