Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
udf
I require a function to trim this
format Last, First in cell A1 to LastF in cell B1 this is required to loop through named jpg files named as in B1 and place pictures in the cell. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
udf
This excel function placed in B1 will get last name then 1st initial
=LEFT(A1,FIND(",",A1)-1) & MID(A1,FIND(",",A1)+2,1) "Ian Bartlett" wrote: I require a function to trim this format Last, First in cell A1 to LastF in cell B1 this is required to loop through named jpg files named as in B1 and place pictures in the cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|