G'day Jeff from Australia,

Both these problem need you to call on the CHARACTER functions i
excel. These are workbook functions not macros or VBA

For example to get the first letter of Col B and underscore and th
Surname to appear in column C

Presuming you are on row 2, you would use this formula in cell C2

=B2&"_"&LEFT(A2,1)

The second problem is easier. You need only capture the last
characters on the right of your referenced cell.

Try this; Assuming the number 543672891 is in cell D2

=RIGHT(D2,4)
The 4 indicates how many digits from the right you want to read.

Pauly

--
Message posted from http://www.ExcelForum.com