Find position of the first lowercase in cell

**jopelou** · 01-09-2013, 07:48 AM

I have in the first column something like this:

GLOBAL DESCRIPTION
GLOBAL DESCRIPTION1 Particular description1
GLOBAL DESCRIPTION1 Particular description2
GLOBAL DESCRIPTION2
GLOBAL DESCRIPTION2 Particular description1
GLOBAL DESCRIPTION2 Particular description2

I want to to have in the second column:

GLOBAL DESCRIPTION1
Particular description1
Particular description2
GLOBAL DESCRIPTION2
Particular description1
Particular description2

So far I have this: +IF(EXACT(A1;UPPERCASE(A1));A1;+RIGHT(A1;LEN(A1)-(FIND(X;A1;1)-1)))

X standing for the position of the first lowercase, which I don't know how to get.

Can anyone help? Thanks.

**jraj1106** · 01-09-2013, 08:22 AM

Hi

I m not sure if this will help you. But try this code:

findposlowercase.xlsm

**jopelou** · 01-09-2013, 08:38 AM

jraj1106, I'm afraid your code doesn't work.

The file I'm using is a Bill Of Quantities (BOQ). The scheme I used was to illustrate the organization of the BOQ, every cell has a different value.

**twiggywales** · 01-09-2013, 08:26 AM

how about this

=TRIM(RIGHT(A1,MIN(FIND(CHAR(ROW($A$97:$A$122)),A1&CHAR(ROW($A$97:$A$122)),1))+1))

you'll have to change your delimiter though i think "," = ";" in your version

**twiggywales** · 01-09-2013, 08:31 AM

also i forgot to mention this is an array formula

(you need to enter with CONTROL + SHIFT + ENTER)

**twiggywales** · 01-09-2013, 08:39 AM

can you post up a sample

or does mine work?

**jopelou** · 01-09-2013, 10:32 AM

sample.xlsx

twiggy, I can't make your work either, but I'm not sure what info I should put in the ROW function! I uploaded a sample of the file.

**twiggywales** · 01-09-2013, 11:14 AM

try this

sample.xlsx

**jopelou** · 01-09-2013, 11:30 AM

That worked. Thank you very much.

Best regards,
JP.

**twiggywales** · 01-09-2013, 11:33 AM

no problem glad to help

remember to mark it solved and star tap the helpers

Find position of the first lowercase in cell

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Find position of the first lowercase in cell

Re: Find position of the first lowercase in cell

Re: Find position of the first lowercase in cell

Re: Find position of the first lowercase in cell

Re: Find position of the first lowercase in cell

Re: Find position of the first lowercase in cell

Re: Find position of the first lowercase in cell

Re: Find position of the first lowercase in cell

Re: Find position of the first lowercase in cell

Re: Find position of the first lowercase in cell

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions