Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help! Excel Question
I have two columns of information
Column A is a name and column B is a Text Field..... here is what I want to be able to do: Here are two examples: If coumn A has Jane Doe and column B has T3866 how can I make column C automatically become *Jane Doe* and column D become *T38666683T* What I am wanting to do is take a list of names and add a leading and lagging * and then take the next field add the text in reverse order and then add a leading and lagging *. The second example is John Doe 12345 (columns A and B) - I would want columns C and D to be *John Doe* *1234554321*. Is this doable? How? Thanks in advance for any help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help! Excel Question
I wonder why you have chosen to do this and whether there may be a better
way of achieving your objective. Sometimes it's better to express a problem in terms of what you're ultimately trying to achieve instead of how you perceive a solution. Regards. Bill Ridgeway Computer Solutions wrote in message oups.com... I have two columns of information Column A is a name and column B is a Text Field..... here is what I want to be able to do: Here are two examples: If coumn A has Jane Doe and column B has T3866 how can I make column C automatically become *Jane Doe* and column D become *T38666683T* What I am wanting to do is take a list of names and add a leading and lagging * and then take the next field add the text in reverse order and then add a leading and lagging *. The second example is John Doe 12345 (columns A and B) - I would want columns C and D to be *John Doe* *1234554321*. Is this doable? How? Thanks in advance for any help! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help! Excel Question
why another column
for each c in selection c.value= "*" & c & "*" next c -- Don Guillett SalesAid Software wrote in message oups.com... I have two columns of information Column A is a name and column B is a Text Field..... here is what I want to be able to do: Here are two examples: If coumn A has Jane Doe and column B has T3866 how can I make column C automatically become *Jane Doe* and column D become *T38666683T* What I am wanting to do is take a list of names and add a leading and lagging * and then take the next field add the text in reverse order and then add a leading and lagging *. The second example is John Doe 12345 (columns A and B) - I would want columns C and D to be *John Doe* *1234554321*. Is this doable? How? Thanks in advance for any help! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help! Excel Question
Hi Bill,
1. ="*"&A1&"*" 2. ="*"&B1&RIGHT(B1,1)&MID(B1,4,1)&MID(B1,3,1)&MID(B1 ,2,1)&LEFT(B1,1)&"*" HTH Cheers Carim |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help! Excel Question
Thanks! Worked like a charm! You guys are great!'
Lee Carim wrote: Hi Bill, 1. ="*"&A1&"*" 2. ="*"&B1&RIGHT(B1,1)&MID(B1,4,1)&MID(B1,3,1)&MID(B1 ,2,1)&LEFT(B1,1)&"*" HTH Cheers Carim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel files in separate program windows | Excel Discussion (Misc queries) | |||
excel novice question on filling in missing fields/cells | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |