| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
simple cell formating question.
Ok so i have a column with cells like this:
Persons name - Number I want to create soemthing that will automatically change it to this: Number there are different names and different numbers so im not sure how to go about it. Any help would be great thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
simple cell formating question.
=--RIGHT(A2,LEN(A2)-Find("-",A2)-2)
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Ewing25" wrote in message ... Ok so i have a column with cells like this: Persons name - Number I want to create soemthing that will automatically change it to this: Number there are different names and different numbers so im not sure how to go about it. Any help would be great thanks! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
simple cell formating question.
sorry im not sure where to put that?
If i put it in a cell it just gives me zero and it rejects it in VBA "Bob Phillips" wrote: =--RIGHT(A2,LEN(A2)-Find("-",A2)-2) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Ewing25" wrote in message ... Ok so i have a column with cells like this: Persons name - Number I want to create soemthing that will automatically change it to this: Number there are different names and different numbers so im not sure how to go about it. Any help would be great thanks! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
simple cell formating question.
Just kidding i figured it out
Thanks! worked perfectly "Ewing25" wrote: sorry im not sure where to put that? If i put it in a cell it just gives me zero and it rejects it in VBA "Bob Phillips" wrote: =--RIGHT(A2,LEN(A2)-Find("-",A2)-2) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Ewing25" wrote in message ... Ok so i have a column with cells like this: Persons name - Number I want to create soemthing that will automatically change it to this: Number there are different names and different numbers so im not sure how to go about it. Any help would be great thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simple cell formating question | Excel Worksheet Functions | |||
| CELL LOCATION!! SIMPLE QUESTION!!!! | Excel Discussion (Misc queries) | |||
| Simple question - auto populate cells - dependent on other cell value. | Excel Discussion (Misc queries) | |||
| Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
| Question on custom formating cell | Excel Programming | |||
Linear Mode
