我如何阅读下一个字符 [英] How do I read in the next character

问题描述

我知道这是最基本的问题，但我读到的一切都超出了我的要求。我是Excel开发人员，所以我需要帮助。

I know this is the most basic question but everything I read is way beyond the question I am asking. I am an Excel developer so I need help.

如果提示后面的单词是"weight"，那么我想要这封信，"w"。我也将寻找回车和看起来像°的字符，基本上是一个空格。

If the word after the prompt is, "weight" I want the letter, "w". I will also be looking for the carriage return and the character that looks like ° and is basically a space.

推荐答案

不确定你是什么意思是'提示后'但是我 认为你需要使用MID函数，

Not sure what you mean by 'after the prompt' but I  think you need to be using the MID function,

以下将在即时窗口输出w。

the following will output w in immediate window.

Debug.print Mid（" weight" ，1,1）

Debug.print Mid("weight",1,1)

查看INSTR函数以搜索子字符串的字符串。

see the INSTR function for search a string for a substring.

这篇关于我如何阅读下一个字符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！