ExcelBanter - Substring

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

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

- - Substring (https://www.excelbanter.com/excel-discussion-misc-queries/130816-re-substring.html)

Petya

Substring

Hi,

try that. =MID(A1,6,5)

regards
Pete

"Ldyflyr" wrote:

Hi:

I have a file with 30 characters of text. I want to start with the 6th
character and count 5 places, and have those, and only those characters show
up in a specific cell.
(e.g. if the string iis in A1, I want characters 6-10 to show up in B1. I
think I need a function, but not sure of the syntax.

What do I do?

Thanks

All times are GMT +1. The time now is 07:28 AM.