Thread: Substring
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ldyflyr Ldyflyr is offline
external usenet poster
 
Posts: 7
Default Substring

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