#1   Report Post  
Posted to microsoft.public.excel.misc
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Substring Petya Excel Discussion (Misc queries) 0 February 15th 07 02:53 PM
Substring in excel? How about regular expressions? Samuel Excel Discussion (Misc queries) 8 May 22nd 06 04:43 PM
can I execute and 'substring' function in Excel Larry Excel Worksheet Functions 4 January 1st 06 08:16 PM
Sumproduct based on substring? altopalo Excel Worksheet Functions 4 July 16th 05 04:53 PM
Vlookup using a substring for evaluation? frosterrj Excel Worksheet Functions 6 December 22nd 04 01:23 AM


All times are GMT +1. The time now is 11:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"