Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |