Obtaining the first seven characters of a text cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michael McClellan - 30 Jun 2004 00:09 GMT

I am trying to obtain the first seven characters of text in a given cell
in excel using VBA.

i.e. - a cell contains the text HMA4178A. I want to pass the HMA4178 to
a variable in VBA to be used with the dir statement.

Does anyone have any idea?

Reply to this Message

Poh - 30 Jun 2004 04:23 GMT

Hi, try using this function
=Right([Cell Reference or Text String],7)

>-----Original Message-----
>
[quoted text clipped - 9 lines]
>Don't just participate in USENET...get rewarded for it!
>.

Reply to this Message

Martin Los - 30 Jun 2004 15:01 GMT

strResult =Left(Cell reference or Text String, 7) would do
the trick!

Martin

>-----Original Message-----
>Hi, try using this function
[quoted text clipped - 17 lines]
>>
>.

Reply to this Message