ExcelBanter - Finding a Character in a String Using VBA

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Finding a Character in a String Using VBA (https://www.excelbanter.com/excel-discussion-misc-queries/227149-finding-character-string-using-vba.html)

BVass

Finding a Character in a String Using VBA

Hi,

I am trying to return an integer for the number of characters from the left
of a string that the character "/" is located.

I need to do this using VBA as I am trying to trim the value of a cell.

Can anyone help?

BVass

Jim Cone[_2_]

Finding a Character in a String Using VBA

Use the InStr function...
InStr(start, string1, string2, compare type)

--
Jim Cone
Portland, Oregon USA

"BVass"

wrote in message
Hi,
I am trying to return an integer for the number of characters from the left
of a string that the character "/" is located.
I need to do this using VBA as I am trying to trim the value of a cell.
Can anyone help?
BVass

BVass

Finding a Character in a String Using VBA

Thanks Jim....you are a life saver!!!!

"Jim Cone" wrote:

Use the InStr function...
InStr(start, string1, string2, compare type)

--
Jim Cone
Portland, Oregon USA

"BVass"

wrote in message
Hi,
I am trying to return an integer for the number of characters from the left
of a string that the character "/" is located.
I need to do this using VBA as I am trying to trim the value of a cell.
Can anyone help?
BVass

All times are GMT +1. The time now is 02:45 PM.