Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Split cell based on uppercase letter
Hi
A colleague has SurnameFirstname in a cell - well, in 900 cells! I am trying to come up with a way of splitting the cell before the uppercase letter. I've tried CODE and realise it's uppercase if its CODE is less than 97 but beyond that, I'm stuck! Once I've got a space or other delimiter in there, it'll be easy! Cheers. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Split cell based on uppercase letter
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Split cell based on uppercase letter
On Friday, 7 March 2014 16:00:31 UTC, wrote:
Hi A colleague has SurnameFirstname in a cell - well, in 900 cells! I am trying to come up with a way of splitting the cell before the uppercase letter.. I've tried CODE and realise it's uppercase if its CODE is less than 97 but beyond that, I'm stuck! Once I've got a space or other delimiter in there, it'll be easy! Cheers. Brilliant! Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find the UPPERCASE letter in a string | Excel Worksheet Functions | |||
How to split cell based on capitalised suburb name | Excel Discussion (Misc queries) | |||
Split cell based on UPPERCASE text | Excel Discussion (Misc queries) | |||
split cell in number-cell and letter-cell | Excel Programming | |||
value of a cell based upon column letter and variable for row# | Excel Programming |