Excel 2003 Please Help With CONCAT Dilemma
Solved/Closed
Related:
- Excel 2003 Please Help With CONCAT Dilemma
- Sumifs excel 2003 ✓ - Forum - Excel
- Excel 2003 compatibility pack - Download
- Convert date into words(english) in excel 2003, 2007 or 2010 ✓ - Forum - Excel
- Excel 2003 days before a certain date ✓ - Forum - Excel
- Excel 2003 - Change Row Colour with VBA ✓ - Forum - Excel
1 reply
aquarelle
Feb 7, 2009 at 03:33 AM
- Posts
- 7104
- Registration date
- Saturday April 7, 2007
- Status
- Anonymous
- Last seen
- May 24, 2022
Feb 7, 2009 at 03:33 AM
Hi,
Try this formula : ="prxyz,"&A1&",0699,"&"ABCD"&IF(LEN(B1)=9; B1&"0";B1)&",xxx"
Concerning the column A format, you could also use the format text.
Best regards
Try this formula : ="prxyz,"&A1&",0699,"&"ABCD"&IF(LEN(B1)=9; B1&"0";B1)&",xxx"
Concerning the column A format, you could also use the format text.
Best regards
Feb 8, 2009 at 12:37 PM
It's showing up a formula error... but I've found a formula that works though! Here it is:
="prxyz,"&TEXT(A1,"00000")&",0699,ABCD"&IF(LEN(B1)=9,B1*10,B1)&",xxx"
:)