Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Change all the string values in Excel column?

Tags:

excel

I have a column. THe column is the number 2 all the way down.

What is the fastest way to make all the cells in this column a 3?

The values are of string datatype I believe.

like image 573
JoJo Avatar asked Sep 22 '10 15:09

JoJo

1 Answers

  • Click the first "2" cell
  • Press Control+Shift+DownArrow
  • Press the 3 key
  • Press Control+Enter
  • See if it did what you thought you wanted
like image 172
Mike Woodhouse Avatar answered Nov 10 '22 21:11

Mike Woodhouse
Sign in to Comment

Related questions

multi-sheet import with oledb netting "_xlnm#_FilterDatabase" as sheet names
How can I shorten this VBA code? Copying and pasting cells
Converting VBA Collection to Array
is there quick way to export an array to Excel file using C#?
How can I obtain the displayed value instead of actual value in Excel?
VBA: How to get the last used cell by VBA code when the last error occured in a Workbook/Worksheet?
VBA for clear value in specific range of cell and protected cell from being wash away formula
Convert large CSV files to JSON [closed]
Can I use VBA to detect if a number is stored as text in a cell?
Change Datarow field value
Deleting all the data series in a dynamic chart
VBA: Else without If Error
Copy and Paste a set range in the next empty row
Styling cell borders with PhpSpreadsheet PHP
How do I disable and enable macros on the fly?
Excel/VBA Automation Errors due to Office Service Pack 3.0 caused by Forms
Best free Excel writer for C# to output datatable to excel
How can I kill task manager processes through VBA code?
A whole sheet into a panda dataframe with xlwings
Read Excel worksheet into DataTable using ClosedXML

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!