| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
split cell value
Hi,
I have a huge data contains names of the customer in a single column, i want to take out the first letter of the first name in the word and add with a dot. Example If the name in the column A1 - Tiger Woods , i want the result in B2 as T.W. Sachin R Tendulkar - S.R.T. Adam Gilly Jr - A.G.Jr. -- Thanks and all your help will be much appriciated |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Split a cell | New Users to Excel | |||
| How do i split a cell? | Excel Discussion (Misc queries) | |||
| split a cell diagonally in excell - a calendar -2 dates in 1 cell | Excel Discussion (Misc queries) | |||
| Split a cell | Excel Discussion (Misc queries) | |||
| How can I split one cell into two cell parts (upper & lower)? | Excel Discussion (Misc queries) | |||
Threaded Mode
