| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SHORT KEY | Excel Discussion (Misc queries) | |||
| short key | Excel Discussion (Misc queries) | |||
| Need a short cut for this... | Excel Worksheet Functions | |||
| Return a block of text based on a single "short name" entry | Excel Worksheet Functions | |||
| short cut | Setting up and Configuration of Excel | |||
![Arup C[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
