| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change Text
An apparent simple task...
I want to change the following Text "Surname, NameXXX" into "Surname, Name (XXX)" Is there a formula or Macro for this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change Text
What is that Triple X?
"fak119" wrote: An apparent simple task... I want to change the following Text "Surname, NameXXX" into "Surname, Name (XXX)" Is there a formula or Macro for this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change Text
XXX stands (in this case) for three capital letters, such as "USA"
"Jaleel" wrote: What is that Triple X? "fak119" wrote: An apparent simple task... I want to change the following Text "Surname, NameXXX" into "Surname, Name (XXX)" Is there a formula or Macro for this? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change Text
=LEFT(A1,LEN(A1)-3)&" ("&RIGHT(A1,3)&")"
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "fak119" wrote in message ... XXX stands (in this case) for three capital letters, such as "USA" "Jaleel" wrote: What is that Triple X? "fak119" wrote: An apparent simple task... I want to change the following Text "Surname, NameXXX" into "Surname, Name (XXX)" Is there a formula or Macro for this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text Color Change prompted by different columns | Excel Worksheet Functions | |||
| Change the tooltip text for a datapoint | Charts and Charting in Excel | |||
| How do I change the default cell formatting to be text? | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| how do I change the text case of imported data in excel? | Excel Discussion (Misc queries) | |||
Linear Mode
