formulae for adding a forward slash automatically into a cell
 

Hi every1,

I'm sort new to excel and im looking for a formulae to automatically
add a forward slash after every 3rd number and before the 4th number.

If anyone can help it would be greatly appreciated

Thanks


--
angelgrant
------------------------------------------------------------------------
angelgrant's Profile: http://www.excelforum.com/member.php...o&userid=35620
View this thread: http://www.excelforum.com/showthread...hreadid=553984

formulae for adding a forward slash automatically into a cell
 

=LEFT(A1,3)&"\"&MID(A1,4,99)

Vaya con Dios,
Chuck, CABGx3



"angelgrant" wrote:


Hi every1,

I'm sort new to excel and im looking for a formulae to automatically
add a forward slash after every 3rd number and before the 4th number.

If anyone can help it would be greatly appreciated

Thanks


--
angelgrant
------------------------------------------------------------------------
angelgrant's Profile: http://www.excelforum.com/member.php...o&userid=35620
View this thread: http://www.excelforum.com/showthread...hreadid=553984

formulae for adding a forward slash automatically into a cell
 

"angelgrant" wrote:
I'm sort new to excel and im looking for a formulae to automatically
add a forward slash after every 3rd number and before the 4th number.

One try ..

Assuming numbers in A1 down,

Put in B1:
=IF(LEN(A1)=0,"",IF(LEN(A1)<4,A1,LEFT(A1,3)&"\"&MI D(A1,4,99)))
Copy down

I've assumed that numbers less than 4 digits are to be left untouched
(the "99" in MID is just an arbitrary figure)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

formulae for adding a forward slash automatically into a cell
 

This one assumes that no slash should be desired it the value were TEXT.

=IF(ISTEXT(A1),A1,IF(LEN(A1)=0,"",IF(LEN(A1)<4,A1, LEFT(A1,3)&"\"&MID(A1,4,99))))

Vaya con Dios,
Chuck, CABGx3



"angelgrant" wrote:


Hi every1,

I'm sort new to excel and im looking for a formulae to automatically
add a forward slash after every 3rd number and before the 4th number.

If anyone can help it would be greatly appreciated

Thanks


--
angelgrant
------------------------------------------------------------------------
angelgrant's Profile: http://www.excelforum.com/member.php...o&userid=35620
View this thread: http://www.excelforum.com/showthread...hreadid=553984

formulae for adding a forward slash automatically into a cell
 

If the characters are all numbers, and the number of characters is
consistent, you could use cell formatting:

Select the cells, and choose FormatCells
On the Number tab, select the Custom category
In the text box, enter: 000"/"000
Click OK

angelgrant wrote:
Hi every1,

I'm sort new to excel and im looking for a formulae to automatically
add a forward slash after every 3rd number and before the 4th number.

If anyone can help it would be greatly appreciated

Thanks




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html