Finding capitals in a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to setup a formula to take capital letters from one cell, and using concatenate, copy those capitals and two other cells to a fourth cell

MID won't do it as the length of the words changes, is there a way to find the blank space before the capital and count on one character so that I can copy that and any other new word capitals into the new cell

Thanks in advance.
 
Can you give an example how a cell content can look and what you would want
happen with it?

--

Regards,

Peo Sjoblom


Phil Evelyn said:
I need to setup a formula to take capital letters from one cell, and using
Click to expand...
concatenate, copy those capitals and two other cells to a fourth cell.
MID won't do it as the length of the words changes, is there a way to find
Click to expand...
the blank space before the capital and count on one character so that I can
copy that and any other new word capitals into the new cell?
 
Back
Top