| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I add text to existing text in a whole column in Excel?
I have a column of data e.g.
k2747whi k4870whi k4871whi and I need to add the same text to the start of the entire column to achieve: mk/k2747whi mk/k4870whi mk/k4871whi Any ideas? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I add text to existing text in a whole column in Excel?
Highlight column and try 'edit' replace.
replace 'k' with 'mk/k'. Replace All "Robin Laverick" wrote: I have a column of data e.g. k2747whi k4870whi k4871whi and I need to add the same text to the start of the entire column to achieve: mk/k2747whi mk/k4870whi mk/k4871whi Any ideas? Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I add text to existing text in a whole column in Excel?
hi, with an auxiliar column, lets say B (assuming your data are on A), use
="mk/"&a2 copy it down hth regards from Brazil Marcelo "Robin Laverick" escreveu: I have a column of data e.g. k2747whi k4870whi k4871whi and I need to add the same text to the start of the entire column to achieve: mk/k2747whi mk/k4870whi mk/k4871whi Any ideas? Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I add text to existing text in a whole column in Excel?
Concatenate your existing coloumn with an adjacent column by using the
following simplification. ="mk/"&a1 in any coloumn and replicate the result. Finally copy and special paste it in another coloumn. Surely it can work for you. "Robin Laverick" wrote: I have a column of data e.g. k2747whi k4870whi k4871whi and I need to add the same text to the start of the entire column to achieve: mk/k2747whi mk/k4870whi mk/k4871whi Any ideas? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| How do I hide text beyond the last column in Excel? | Excel Discussion (Misc queries) | |||
| getting excel to print text equal to a column | Excel Discussion (Misc queries) | |||
| Sort or Filter option? | Excel Worksheet Functions | |||
Linear Mode
