Thread: Substring
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Petya Petya is offline
external usenet poster
 
Posts: 9
Default 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