Short cut way to add text
 

Hi Everybody,
Is there any way to add text to another text ? The data I have like this
Jan
Feb
Mar (all in text format)
Now I want to add -07 to each of them so that they become Jan-07, Feb-07 and
Mar-07 in with very few steps (the lesser steps are better)

Short cut way to add text
 

=A2&"-07" and copy down.
--
David Biddulph

"Arup C" wrote in message
...
Hi Everybody,
Is there any way to add text to another text ? The data I have like this
Jan
Feb
Mar (all in text format)
Now I want to add -07 to each of them so that they become Jan-07, Feb-07
and
Mar-07 in with very few steps (the lesser steps are better)

Short cut way to add text
 

try this
Sub addtexttovalues()
For Each c In Range("a2:a22")
If Not IsNumeric(c) Then 'in case of numbers
c.NumberFormat = "@"
c.Value = c.Value & "-07"
End If
Next c
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Arup C" wrote in message
...
Hi Everybody,
Is there any way to add text to another text ? The data I have like this
Jan
Feb
Mar (all in text format)
Now I want to add -07 to each of them so that they become Jan-07, Feb-07
and
Mar-07 in with very few steps (the lesser steps are better)