Help

S

Simon

Can anyone help with the following.

I have 'AC4031028536' in cell 'A1'. In cell 'B1' I want
it to pull data from cell 'A1' and put it in a format like
this '403/10285' (These numbers are at the middle)

Thanks
Simon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
If, Or, and 5
Excel does not accept text format! 0
=substitute 2
Referencing the values of multiple cells in conditinal formatting. 0
Newbie Help - IF Yes No Function 0
CONDITIONAL FORMATTING IN EXCEL 2010 1
SUMIF with criteria "<>" & "=" 4

Top