| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
bad at using functions ...
Can someone help me figure this out?
HOW IT IS NOW: Doe,Jane HOW I WANT IT TO BE: Doe, Jane Basically, I want a space in between the comma and the first name. Also, here is another one: HOW IT IS NOW: Doe,Jane,Smith HOW I WANT IT TO BE: Doe, Jane, Smith THANK YOU! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
bad at using functions ...
Do a find and replace on the comma replacing with comma blank space... Record
it as a macro if you need... -- HTH... Jim Thomlinson "mira" wrote: Can someone help me figure this out? HOW IT IS NOW: Doe,Jane HOW I WANT IT TO BE: Doe, Jane Basically, I want a space in between the comma and the first name. Also, here is another one: HOW IT IS NOW: Doe,Jane,Smith HOW I WANT IT TO BE: Doe, Jane, Smith THANK YOU! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
bad at using functions ...
Select the column or cells of data to change and do
Edit=Replace What: , with: ,<space use an actual space. -- Regards, Tom Ogilvy "mira" wrote in message ... Can someone help me figure this out? HOW IT IS NOW: Doe,Jane HOW I WANT IT TO BE: Doe, Jane Basically, I want a space in between the comma and the first name. Also, here is another one: HOW IT IS NOW: Doe,Jane,Smith HOW I WANT IT TO BE: Doe, Jane, Smith THANK YOU! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple functions, conditional functions | Excel Worksheet Functions | |||
| How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
| efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
| Looking for a site with functions that substitute the ATP functions | Excel Worksheet Functions | |||
| excel functions and User defined functions | Excel Programming | |||
Linear Mode
