| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
string.matchPattern ???
Hi there,
i tried to find a function where i can check if there are two or eight blanks in front of a string. How is this possible? Best regards, drofluga |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
string.matchPattern ???
if all the blanks will be on the left side this will give you the count
=len(A1)-len(substitute,A1," ")) If only two or 8 and it has to be one or the other =if(mid(a1,3,1)=" ",8,2) or tell us more -- Regards, Tom Ogilvy "drofluga" wrote: Hi there, i tried to find a function where i can check if there are two or eight blanks in front of a string. How is this possible? Best regards, drofluga |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
string.matchPattern ???
Thanks for the hint. It worked!
Greetings ;-) Tom Ogilvy schrieb: if all the blanks will be on the left side this will give you the count =len(A1)-len(substitute,A1," ")) If only two or 8 and it has to be one or the other =if(mid(a1,3,1)=" ",8,2) or tell us more -- Regards, Tom Ogilvy "drofluga" wrote: Hi there, i tried to find a function where i can check if there are two or eight blanks in front of a string. How is this possible? Best regards, drofluga |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change 3 letter text string to a number string | Excel Discussion (Misc queries) | |||
| Importing Long String - String Manipulation (INVRPT) (EDI EANCOM 96a) | Excel Programming | |||
| Importing Long String - String Manipulation (EDI EANCOM 96a) | Excel Programming | |||
| to search for a string and affect data if it finds the string? | Excel Worksheet Functions | |||
| Create a formula into a String then assign string to a cell | Excel Programming | |||
Hybrid Mode
