in my sheet, i have what is call the work center:
A1: 5011ua
A2: 4322ua
in column b, i want to know what the 4th character is:
B1: 1
B2: 2
please help
thanks
in my sheet, i have what is call the work center:
A1: 5011ua
A2: 4322ua
in column b, i want to know what the 4th character is:
B1: 1
B2: 2
please help
thanks
in cell B1 the formula:
=mid(A1,4,1)
and copy it down the column.
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
thank you
Hi chungtinlak,
Do a search for String in Excel Help and you'll find various functions you can use for getting text from a string.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'