Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replace a character by it's place in a string
Hoping there's an easy way to do this.
Tried the hard way (Left, Right) and it works but I was looking for an easier way. I need to replace a character in a string by it's position in the string. i.e. String = "aaaaaaaa" Replace the 5th character with "Chr(10)" Result = "aaaa(Chr(10))aaa" Thanks for your help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replace a character by it's place in a string
perhaps
Sub test() Dim strTemp As String strTemp = "aaaaaaaa" strTemp = Application.Replace(strTemp, 5, 1, Chr(10)) MsgBox strTemp End Sub "John Wilson" wrote: Hoping there's an easy way to do this. Tried the hard way (Left, Right) and it works but I was looking for an easier way. I need to replace a character in a string by it's position in the string. i.e. String = "aaaaaaaa" Replace the 5th character with "Chr(10)" Result = "aaaa(Chr(10))aaa" Thanks for your help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replace a character by it's place in a string
Here is one way... Sub abc() Dim str As String str = "aaaaaaaa" Mid$(str, 5, 1) = Chr$(10) MsgBox str End Sub -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "John Wilson" wrote in message Hoping there's an easy way to do this. Tried the hard way (Left, Right) and it works but I was looking for an easier way. I need to replace a character in a string by it's position in the string. i.e. String = "aaaaaaaa" Replace the 5th character with "Chr(10)" Result = "aaaa(Chr(10))aaa" Thanks for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replace font of one character in a string | Excel Programming | |||
How replace a character in a string of characters? | Excel Programming | |||
Replace character in string, not document | Excel Programming | |||
Function to return Character Position of Xth character within a string | Excel Programming | |||
How do I replace * as a character in a string in Excel? | Excel Programming |