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
|