Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if and replace function?
Hello
I need help I have names on my left and depending on the name I need to remove a space Original data Answer John, Repp John,Repp Jay, Thorp Jay, Thorp Jana, Washington Jana,Washington So just depending on the name some need the space after the "," trim and some dont I have a total of about 40 names only about 6 dont need the space after the coma. I was thinking of Replace and If But I cant seem to put it together. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if and replace function?
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if and replace function?
On Wednesday, May 22, 2013 12:57:40 PM UTC-5, wrote:
Hello I need help I have names on my left and depending on the name I need to remove a space Original data Answer John, Repp John,Repp Jay, Thorp Jay, Thorp Jana, Washington Jana,Washington So just depending on the name some need the space after the "," trim and some dont I have a total of about 40 names only about 6 dont need the space after the coma. I was thinking of Replace and If But I cant seem to put it together. There are certain names that have to remain the same as the original data but another 36 or so I have to trim the space after the comma So I would have to hard code those 36 names in the formula if you can just hard code 2 for me I can do the rest. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if and replace function?
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if and replace function?
Hi again,
Am Wed, 22 May 2013 20:58:39 +0200 schrieb Claus Busch: =IF(COUNTIF($H$1:$H$36,A1)=0,SUBSTITUTE(A1,", ",","),A1) if there are only 6 names to remove the space it is easier to write this 6 names in column H and then: =IF(COUNTIF($H$1:$H$6,A1)0,SUBSTITUTE(A1,", ",","),A1) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if and replace function?
On Wednesday, May 22, 2013 12:57:40 PM UTC-5, wrote:
Hello I need help I have names on my left and depending on the name I need to remove a space Original data Answer John, Repp John,Repp Jay, Thorp Jay, Thorp Jana, Washington Jana,Washington So just depending on the name some need the space after the "," trim and some dont I have a total of about 40 names only about 6 dont need the space after the coma. I was thinking of Replace and If But I cant seem to put it together. Thank you Clause this works great |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
len replace function | Excel Programming | |||
Can you have a value created by a function replace the function? | Excel Worksheet Functions | |||
Using the replace function less | Excel Worksheet Functions | |||
Replace Function | Excel Discussion (Misc queries) | |||
Replace XLA with XLL function | Excel Programming |