View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] radlee@progressivetel.com is offline
external usenet poster
 
Posts: 5
Default 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!