InvestorsHub Logo
Boards
News
Market Data
Markets
Discover
Discover
Subscribe Login/Register
S&P 500
5,187.70
(
0.13%
)
US TECH 100
17,607.60
(
-0.03%
)
Dow Jones
38,884.26
(
0.08%
)
Brent Oil
82.26
(
-0.74%
)
Bitcoin
62,253.70
(
-0.13%
)
Post# of 162
Next 10
Reply Private New
Public Reply Private Reply New Post
Keep Last Read
Replies (1) Keep Next 10 Report Keyboard Shortcuts
Replies (1) Next 10 Prev Next

MSC290

Send PM Follow Ignore
Followers 20
Posts 1704
Boards Moderated 0
Alias Born 01/02/2003

MSC290

Member Level

Re: lobogotti post# 117

Tuesday, 11/14/2006 9:33:14 AM

Tuesday, November 14, 2006 9:33:14 AM

Post# of 162
Solutions for the problem:

#1 (the easy way) Go to the Learning Microsoft Excel board and post a message to lobogotti and say HELP!

#2 (the hard way) Tax your brain for quite some time doing numerous trials and errors to come up with the following formula to place in cell B1:

=CONCATENATE(MID(A1,1,1),"*",MID(A1,2,1),"*",MID(A1,3,1),"*",MID(A1,4,1),"*",MID(A1,5,1),"*",MID(A1,6,1),"*",MID(A1,7,1))
Public Reply Private Reply New Post
Keep Last Read
Replies (1) Keep Last Read Next 10 Report Keyboard Shortcuts
Replies (1) Next 10 Prev Next

Join the InvestorsHub Community

Register for free to join our community of investors and share your ideas. You will also get access to streaming quotes, interactive charts, trades, portfolio, live options flow and more tools.

Sign Up