Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add to a "number as text"
With a list of text as these two examples, (each in one cell, A1, A2 etc.) 03:04 stuff etc things whatever 04:23 bla bla bla bla How can I add say, 5 seconds to the :04 and the :23 And have the list look like this: 03:09 stuff etc things whatever 04:28 bla bla bla bla And it might be good to know how to add 1.05 to the strings and have it look like this: 04:09 stuff etc things whatever 05:28 bla bla bla bla This code pulls the correct seconds strings out but I'm lost on how to add to 5 to a "number as text" and throw it back into the text statement. To add 1.05, the code would need to be changed to include the minutes and seconds is my guess. Thanks, Howard Sub StringAddFour() Dim LRow As Long Dim aRng As Range Dim c As Range Dim strMid As String LRow = Cells(Rows.Count, "A").End(xlUp).Row Set aRng = Range("A1:A" & Cells(Rows.Count, "A").End(xlUp).Row) For Each c In aRng With c strMid = Mid(c, 4, 2) MsgBox strMid End With Next End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how i convert "100" to "hundred"( number to text) in excel-2007 | Excel Worksheet Functions | |||
macro for converting number stored as "text" (or preceeded with ') to "number" formatting | Excel Programming | |||
macro for converting number stored as "text" (or preceeded with ') to "number" formatting | Excel Programming | |||
how to converts a number to text eg. "2" become "two" | New Users to Excel | |||
how to converts a number to text eg. "2" become "two" | New Users to Excel |