Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change cell data using excel 2003
Hello,
I have 100 worksheets with 3 columns of data and 1 row to 500 rows. In column C my data looks like so 125 252 CO125 CO314 MECH MECH2 This is my question - How can I change my data in the cells with CO125 or CO314 to look like this 125CO or 314CO? I've searched for code to help me but I've been unsuccessful! Please Help! Thank you for help, jfcby |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change cell data using excel 2003
The easiest would be a formula in a helper column
With your number in say A1, then in B1 ente =IF(LEFT(A1,2)="CO",RIGHT(A1,LEN(A1)-2)&LEFT(A1,2),IF(LEFT(A1,4)="MECH",RIGHT(A1,LEN(A1 )-4)&LEFT(A1,4),A1)) Copy down. Else you ned to write a macro with a for next loop "jfcby" wrote: Hello, I have 100 worksheets with 3 columns of data and 1 row to 500 rows. In column C my data looks like so 125 252 CO125 CO314 MECH MECH2 This is my question - How can I change my data in the cells with CO125 or CO314 to look like this 125CO or 314CO? I've searched for code to help me but I've been unsuccessful! Please Help! Thank you for help, jfcby |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change cell data using excel 2003
Try:
Sub TestData() Dim MyCell As Range For Each MyCell In Selection If Left(MyCell.Value, 2) = "CO" Then MyCell.Value = Right(MyCell.Value, Len(MyCell.Value) - 2) & "CO" End If Next End Sub Alan jfcby wrote: Hello, I have 100 worksheets with 3 columns of data and 1 row to 500 rows. In column C my data looks like so 125 252 CO125 CO314 MECH MECH2 This is my question - How can I change my data in the cells with CO125 or CO314 to look like this 125CO or 314CO? I've searched for code to help me but I've been unsuccessful! Please Help! Thank you for help, jfcby |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change cell data using excel 2003
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 make 1 date cell automatically change another date cell | Excel Worksheet Functions | |||
how to change data from horizontal to be vertical (Excel 2003) | Excel Discussion (Misc queries) | |||
I want to change the colour of the cell cursor in Excel 2003. | Excel Discussion (Misc queries) | |||
How do I change the order of the data in a pie chart - excel 2003 | Charts and Charting in Excel | |||
Word 2003 Find/Change Automation from Excel 2003 crashes Excel 200 | Excel Programming |